How to transpose a specific data by the Name?

[cloh021]

Hi experts,

i have a pivot table and would like to unpivot the table using alteryx. However can i transpose the following data (original vs what i want to achieve)? For e.g. i have company details which consists of the company name and also the country, but i would like to split the country into a column next to it, how can i do that? Thanks in advance!

Original

Company Details

Tax Jurisdiction : Australia

company a

company b

Tax Jurisdiction : Malaysia

company c

company d

company e

Would like it to become :

Company details	Tax Jurisdiction
company a	Australia
company b	Australia
company c	Malaysia
company d	Malaysia
company e	Malaysia

[Emil_Kos · Accepted solution]

Hi @cloh021,

Multi row formula is a solution to your problem. I have created a workflow for you:

and the output:

Good luck!

Please mark it as a solution if this was helpful for you!

[Emil_Kos]

Hi @cloh021,

Thank you for marking my post as a solution.

Good luck!

[cloh021]

Yess!! It was solved!!Thanks Heaps!!! @Emil_Kos