Hi there,
I have the following sample data:
PARTNUMBER QTY RATe PRUN VALID_FROM_VALID_TO
ZWR1 0.1095 USD 1 20050512 20050526
XREZ12 0.1095 USD 1 20050527 99991231

is it possible to put this data in the following:

20050512 20050526 20050527 99991231
ZWR1 XREZ12
0.1095 0.1095
USD USD
1 1

So basically make the existing Row heading as Column heading, Please advise
if this can be done. Been trying to do with pivot but can't seem to get it to
work.

Really appreciate any help.
Thank YOU,
J