asked on

Moving Data within an Excel workbook

I need a macro or something that can make the table shown below

I have attached a sample file.

Product Name        Quantity      Price
12345678-09878709      1        200
12345678-09878709      25        175
12345678-09878709      100        165
12345678-09878709      500        150
12345678-09878709      1000       125
wqrt 678 ng-iryrbq 6      1        45678
wqrt 678 ng-iryrbq 6      25        43212
wqrt 678 ng-iryrbq 6      100        40009
wqrt 678 ng-iryrbq 6      500        38456
wqrt 678 ng-iryrbq 6      1000 35045
J43h-456        1        7
J43h-456        25        6.5
J43h-456        100        6.25
J43h-456        500        6.13
J43h-456        1000        6
WS402-5089        1       450
WS402-5089       25        435
WS402-5089        100        425
WS402-5089        500        415
WS402-5089        1000      400

Look like this

Product Name        1        25        100        500        1000
12345678-09878709                    200        175        165        150        125
wqrt 678 ng-iryrbq 6                  45678      43212      40009      35045      35045
J43h-456                    7        6.5        6.25        6.13        6
WS402-5089                    450        435        425        415        400
EE-Question.xlsx

terencino

Pivot table will work well for this application
...Terry
EE-Question-pivot.xlsx

ASKER CERTIFIED SOLUTION

terencino

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial