Columns to rows

[TomzPwC]

I was trying to transpose and get some meaning ful information, Input and desired output is attached.

[Yoshiro_Fujimori · Accepted solution]

Hi @TomzPwC ,

Here is one way of doing this.

Workflow

Output

If you do not like the total row with name, you can clear it with Formula tool.

I hope this meets with your requirement.

[TomzPwC]

Thanks @Yoshiro_Fujimori