Reorganizing data in excel file using pivot tables?

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!