Hi Sanjeev

You don't need a pivot table to achieve this.
Mark your whole block of data, got cell A1 on another sheetPaste
SpecialTranspose.

--
Regards

Roger Govier


"Sanjeev Raghavan" <Sanjeev wrote in
message ...
Date 01-04-200702-04-200703-04-200704-04-200705-04-200706-04-2007
GBP 242,32 242,32 243,34 244,07 244,17 243,45
USD 123,84 123,84 123,34 123,55 123,60 123,37
EUR 164,87 164,87 164,67 165,01 165,02 164,83
RUR 4,76 4,76 4,74 4,75 4,76 4,75
Please explain how can I creat a pivot table from the above list to a
table
showing
Date GBP USD EUR RUR pattern
Please advise.