Hi All,
I want to convert my available data which is already being updated from other sheets to pivot format continuously. Suppose. I already have this data in following sheet.
<tbody>
</tbody>
Now i want to link this data in a new table which i can use for reporting as pivot table in following sequence.
<tbody>
</tbody>
Can Anyone help Using Excel, VB or whatsoever. Waiting for early response...
I want to convert my available data which is already being updated from other sheets to pivot format continuously. Suppose. I already have this data in following sheet.
Inv # | Name | Address | Area | VARIETY A | VARIETY B | VARIETY C | AMOUNT |
1 | A | Z | AA | 5 | 10 | 1000 | |
2 | B | Y | BB | 20 | 1500 |
<tbody>
</tbody>
Now i want to link this data in a new table which i can use for reporting as pivot table in following sequence.
INV # | NAME | ADDRESS | AREA | VARIETIES | QTY | RATE | AMOUNT |
1 | A | Z | AA | VAR-A | 5 | 60 | 300 |
1 | A | Z | AA | VAR-C | 10 | 70 | 700 |
2 | B | Y | BB | VAR-B | 20 | 75 | 1500 |
<tbody>
</tbody>
Can Anyone help Using Excel, VB or whatsoever. Waiting for early response...