Reorganizing data in excel file using pivot tables?

[pahari75]

Dear Friends, thanks in advance for your support and help. I have a big excel file where the data needs to be reorganized. To explain what I mean I have created a tiny sample of excel file in the attached file. Sheet 1 mirrors the way data looks now in excel and sheet 2 mirrors what I want it to look eventually.

Please let me know if you cannot understand from the sheet attached. As i said, its just a very tiny version of the real sheet which actually has 1000 columns of company codes and daily dates for 3 years!

[:) Sixthsense :)]

Refer the attached excel for Pivot.

[pahari75]

Thanks Sixthsense, but it doesnt solve the problem. As I said I want the data from sheet 1 to look as it is in sheet 2. Can anyone help in how to get to sheet 2 with pivot tables or perhaps something else?

[:) Sixthsense :)]

You didn't explained what is the difference you seen?