Hello! I am looking for help with how to transpose multiple rows at the top of a spreadsheet within Alteryx. The first three rows of my spreadsheet are all headers for the data below it, so I want to transpose all of them. Below are examples of what I am hoping to do:
Initial Data with first three rows being column headers
Country Name: | US | UK | India |
Country ID: | 101 | 102 | 103 |
Country Loc: | NA | EUR | ASIA |
Sales: | 10 | 11 | 12 |
Costs: | 5 | 10 | 4 |
Profits | 5 | 6 | 8 |
Trying to turn that into the following:
Country Name | Country ID | Country Loc | Type | Value |
US | 101 | NA | Sales | 10 |
UK | 102 | EUR | Sales | 11 |
India | 103 | ASIA | Sales | 12 |
US | 101 | NA | Costs | 5 |
UK | 102 | EUR | Costs | 10 |
India | 103 | ASIA | Costs | 4 |
US | 101 | NA | Profits | 5 |
UK | 102 | EUR | Profits | 6 |
India | 103 | ASIA | Profits | 8 |
Thank you for your help!
Solved! Go to Solution.
Hi @BrianDeg ,
Attached is an example showing how to do it. It was a matter of playing with cross tab and transposes.
Take a look and let me know if that works for you.
Best,
Fernando Vizcaino