Transpose Excel pivot table

[Shahzad]

Dear Members

I would like to know how we can transpose data if it is multi layered pivot table. (please find attachment)

Need your support

BR

Shahzad

[atcodedog05 · Accepted solution]

Hi @Shahzad 

Here is how you can do it. It became slightly complicated then expected.

Workflow:

Hope this helps : )

[AngelosPachis]

Hi @Shahzad ,

Here's a way that you can do it. This solution is not 100% dynamic, as you have to select the records that contain your column headers, in this occasion the top 3 rows.

Hope that helps,

Angelos

[Shahzad]

Thank You 👍

[atcodedog05]

Happy to help : ) @Shahzad 

Cheers and have a nice day!