creating pivot from a horizontal table
Hi,
It is not clear what you mean by pattern?
--
Thanks,
Shane Devenshire
"Sanjeev Raghavan" wrote:
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.
|