We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Reverse of Transpose (Columns to rows and vice-versa)

avisingh96
7 - Meteor
‎06-13-2023 08:06 AM

Hi Community,

 

I want your help in this thing. I want to convert the column headers to rows and the 1st row fields to columns. Basically Columns to rows and row data to columns. I have attached a Sample file in which a Sample input is in the 1st sheet and my desired output is in Sample Output.

 

Please help.

 

FYI - Cross Tab is not working the way I want. If you have any configuration in Cross Tab that can help. Please let me know

Preview file
14 KB
Reply
3 REPLIES 3
npariso
10 - Fireball
‎06-13-2023 08:10 AM

Hi @avisingh96 a combination of the transpose and crosstab tools will get you the correct solution.

npariso_0-1686669300279.png

 

Solution.yxmd
Reply
binuacs
21 - Polaris
‎06-13-2023 08:29 AM

@avisingh96 Similar to @npariso solution

binuacs_0-1686670179723.png

 

Transpose_130623.yxmd
Reply
0 Likes
nagakavyasri
12 - Quasar
‎06-13-2023 10:22 AM

Similar solution:

 

Screenshot 2023-06-13 132015.png

New Workflow7.yxmd
Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All