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 |
