SOLVED
How to Transpose/pivot multiple rows at once?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
BrianDeg
5 - Atom
‎02-12-2020
10:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Tips and Tricks
- Transformation
1 REPLY 1
17 - Castor
‎02-12-2020
10:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
