Sort of Crosstab Query

[JasGun]

Hi,

I have a table example below and I need a query to format it in a different way, but, I am struggling at the moment.

Current Table:

Pol Hdr1 Hdr2
A Type Av
A Date 26/06/2003
A Ccy GBP
B Type NM
B Date 01/07/2003
B Ccy USD

What I need is:

Pol Type Date Ccy
A Av 26/06/2003 GBP
B NM 01/07/2003 USD

I've tried a crosstab but it isn't possible.
Can anyone help?

Thanks

JasGun