Unpivot data

[Pexcel]

Hello Everyone,

I was hoping to get some help on this unpivoting project I am doing.

I have the original table(which is a pivot) in the below form:

[TABLE="width: 256"]
<tbody>[TR]
[TD]ORIGINAL
[/TD]
[TD]entity
[/TD]
[TD]entity
[/TD]
[TD]entity
[/TD]
[/TR]
[TR]
[TD]account
[/TD]
[TD]balance
[/TD]
[TD]balance
[/TD]
[TD]balance
[/TD]
[/TR]
[TR]
[TD]account
[/TD]
[TD]balance
[/TD]
[TD]balance
[/TD]
[TD]balance
[/TD]
[/TR]
[TR]
[TD]account
[/TD]
[TD]balance
[/TD]
[TD]balance
[/TD]
[TD]balance
[/TD]
[/TR]
</tbody>[/TABLE]

Which I have to change to the below form:
[TABLE="width: 192"]
<tbody>[TR]
[TD]account
[/TD]
[TD]entity
[/TD]
[TD]balance
[/TD]
[/TR]
</tbody>[/TABLE]

Any help on this will be greatly appreciated.

 

[V_Malkoti]

Since its a pivot table, I think your pivot source data should already be in that format.

As an alternative, you can get the results by modifying the layout of your pivot - move entity from column labels to row labels.