Previous Topic Next Topic

Transposing

Closed
jusip16
Posts
3
Registration date
Monday March 6, 2017
Status
Member
Last seen
March 9, 2017
 - Mar 6, 2017 at 03:00 AM
Hello,

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