Hi Excel Gurus,

This may sound simple, but am very new to Excel programming.....Please
assist

I have Date values in column A, Item name in column B, Price in column
C of sheet 1, In sheet
2 I have date values as Row Headers, Item Names in Column A1 to A
400..

..I have some 400 Items and the price of each item would vary every
day, so we enter manually the price of each item on a particular day,
in sheet 1, all i need is to have the same data present in Sheet 1 to
sheet 2 but in a different format.... like Dates in rows
B2...D2..C2... items from A2...A 400.... Please assist......

thank you all for your support in advance,
Regards,
kumar