Dear all,

Kindly help me on this. I have been working on a report which i needed to format in order to integrate with a pivot table easily. I have tried several times with a macro but didn't work out. I have attached the report herewith.

1st sheet has original data. 2nd sheet has the format i need. Production Plan.xlsx

The requirement is to get the plan quantities given for each date in horizontally for the month in vertically so i can easily get in to a Pivot table. I had manually copied style+del A2:A165 range 30 times( for each day) and down the cells and similarly copy quantity data in cell range 2:165 of each column(for each date) down the cells under a single quantity column.

Looking forward for your support.