Transposing [Closed]

Report

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

Transposing
Excel transpose formulas from one sheet to another - How-To - Excel
Notepad++ transpose row to column ✓ - Forum - Excel
VBA Code that will find, copy and transpose ✓ - Forum - Excel
Copy and paste/transpose each row by n times ✓ - Forum - Office Software
Inserting/Copy rows, Transpose vba HELP ✓ - Forum - Excel

Transposing [Closed]

Your reply

Subscribe To Our Newsletter!