I am exporting data that is coming in as a pivot summary format (not an actual pivot though).
[TABLE="width: 500"]
<tbody>[TR]
[TD]Group[/TD]
[TD]Volume Held[/TD]
[TD]Volume Sold[/TD]
[/TR]
[TR]
[TD]Week 1 (Sum)[/TD]
[TD]5 (Sum)[/TD]
[TD]6 (Sum)[/TD]
[/TR]
[TR]
[TD]Person A[/TD]
[TD]2[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Person B[/TD]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
How can I turn this (above) back to its un-formatted data (below) so that I can create my own pivot tables?
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Group[/TD]
[TD]Volume Held[/TD]
[TD]Volume Sold[/TD]
[/TR]
[TR]
[TD]Week 1[/TD]
[TD]Person A[/TD]
[TD]2[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Week 1[/TD]
[TD]Person B[/TD]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
Is there an Excel function of some sort of VBA code I can use to do this?
[TABLE="width: 500"]
<tbody>[TR]
[TD]Group[/TD]
[TD]Volume Held[/TD]
[TD]Volume Sold[/TD]
[/TR]
[TR]
[TD]Week 1 (Sum)[/TD]
[TD]5 (Sum)[/TD]
[TD]6 (Sum)[/TD]
[/TR]
[TR]
[TD]Person A[/TD]
[TD]2[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Person B[/TD]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
How can I turn this (above) back to its un-formatted data (below) so that I can create my own pivot tables?
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Group[/TD]
[TD]Volume Held[/TD]
[TD]Volume Sold[/TD]
[/TR]
[TR]
[TD]Week 1[/TD]
[TD]Person A[/TD]
[TD]2[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Week 1[/TD]
[TD]Person B[/TD]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
Is there an Excel function of some sort of VBA code I can use to do this?