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.
SOLVED

Transpose multiple header rows

bradaba33
6 - Meteoroid
‎07-12-2023 02:11 PM

Hello -

 

I'm struggling to properly transpose multiple header rows within the attached TEST file. I've added a "Wanted Output" tab to show what I'm trying to accomplish. The piece I am struggling with, how can I transpose the data and have the values that are currently in Rows 10 and 11 be properly transposed as well.

 

Thanks in advance

Preview file
545 KB
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris
‎07-12-2023 04:15 PM

@bradaba33 
I am sorry but I can not see where the data below coming from?

0713-bradaba33.PNG

Reply
0 Likes
geraldo
13 - Pulsar
‎07-12-2023 05:03 PM

@bradaba33 

 



an example workflow for you to get an idea and improvements

transpose2.yxmd
Reply
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All