View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default 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.