Transposing [Closed]

Registration date
Monday March 6, 2017
Last seen
March 9, 2017

I have a sales report provided to me monthly that has the following details: product code, product name, year and month. The format looks like this

l2017 l2017l 2017 l
Code l Name l JAN l FEB l MAR l

I would like to transpose the data to this format using VBA or formulas so that I can do this automatically every month.

Code l Name l Year l Month l Amount l

Also, new product codes and product names are added every month in the report.

Thank you

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!