Transposing Total Bottom Row To Column

[wonka1234]

Hi,

Having trouble doing this 

Team	Sub Team	Sum_1__Asset	Sum_2__Liability	Sum_3__Equity	Sum_4__Revenue	Sum_5__Expense
Toronto Maple Leafs	Farm Team 1	10	20	30	40	50
Toronto Maple Leafs	Farm Team 2	60	70	80	90	100
Total	Total	70	90	110	130	150

to this -

Team	Sub Team	Sum_1__Asset	Sum_2__Liability	Sum_3__Equity	Sum_4__Revenue	Sum_5__Expense	Total1	Total2	Total3	Total4	Total5
Toronto Maple Leafs	Farm Team 1	10	20	30	40	50	70	90	110	130	150
Toronto Maple Leafs	Farm Team 2	60	70	80	90	100	70	90	110	130	150

I want to do this in order to do some divison to get %'s.

[Luke_C]

Hi @wonka1234 

Here's an example:

• Filter to separate total row from rest of data
• Dynamic rename to rename columns (could use a select but was not sure if you'll have more columns)
• Append total columns