cross tab query

hi there,

this is just an extract of the data,

code****** End_Date
-------**-------------
a*********** 14/7/03
a*********** 14/7/03
a************ 21/7/03
b*************21/7/03
b************* 28/7/03
b************ 28/7/03
b************ 28/7/03
c************ 04/8/03

now i want the data to look like this:

******* 14/7/03**21/7/03**28/7/03**04/8/03
****** --------**--------**-------**--------

a*************2*******1


b*********************1********* 3


c*************************************** 1

can this be done,suggestions appreciated.
regards*

Please...someone help! I'm looking for this too!

This may help you:

(on the Yahoo group IBObjects)
File : /Crosstab.zip
Uploaded by : robert_p_levy <robert_p_levy@y...>
Description : Delphi 5 package source for a designtime/runtime FBCrosstab component encapsulating a client-side parser that simulates a crosstab query when attached to an IBOQuery or IB_Query. Kit includes a demo app. Requires the free Project JEDI JCL libary.

You can access this file at the URL:
http://groups.yahoo.com/group/IBObjects/files/

You can also access it at:
http://www.ibobjects.com/ibocontributed.html