Move data from Columns to rows

[zaveed]

Hi,

I have a excel sheet with the data for the month, in columns, its got historical data for 4 years. I want this data to be displayed in columns.

For a Product AAA, there would be fixed number of data in columns , One months data would be in 10 columns, and then the next month data in next 10 columns. Getting a pivot table with the monthly wise trend is not possible with this data.
Sample 1.JPG


First column of the new sheet should be the month, second column should be the product and from 3rd column it should have corresponding month's data. See below.
Sample 2.JPG

I have done this manually for some months but it takes a lot of time for nearly 48 months of data. I have multiple sheet with multiple data.

Is there a way this can be accomplished through vba? Vb Script should take the report run date , extract the month from this and add this as the first column for all products.

Appreciate the help.

Attached is the sample file.

[zaveed]

Can some please help me out with this . Appreciate it.

Thanks