SOLVED
Rows to column simple transpose
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
kalindideshmukh
7 - Meteor
‎09-03-2019
04:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Designers,
I have the following table:
Location | Parameter 1 | Parameter 2 | Difference | Difference % |
A | 10 | 8 | 2 | 25 |
B | 20 | 14 | 6 | 42.85 |
C | 30 | 20 | 10 | 50 |
How do I convert into simple transpose like this:
Location | A | B | C |
Parameter 1 | 10 | 20 | 30 |
Parameter 2 | 8 | 14 | 20 |
Difference | 2 | 6 | 10 |
Difference % | 25 | 42.85 | 50 |
Thanks in advance.
Kalindi
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
3 REPLIES 3
lmorrell
11 - Bolide
‎09-03-2019
05:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Solution is attached.
The trick here is to push all your values into a single column by transposing your original table, and taking the results of that and crosstabbing it out.
Additionally, to retain the order of the rows - I have created a sort column so that the outputs are visually identical.
Hope this helps!
‎09-03-2019
05:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Imorrell, Thanks a lot!
allanxu23
5 - Atom
‎11-07-2023
06:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can just download the Transpose Excel Style Macro from Alteryx Community.
