Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Tranpose Multiple Columns To Rows

national
6 - Meteoroid

Hello everyone, 

I would like to perform a transpose but I do not know how to do it properly. 
Intially I have this table:

CompanyM01M02M03M04M05M06
A123456
B235124
C3578910
D113312

 

I would like to tranpose it to the table below:

TimeABCD
M011...  
M022...  
M033...  
M044...  


Thank you in advance for your help

3 REPLIES 3
Aaron_Harter
11 - Bolide

Hi @national

 

You'll want to first Transpose the data, then Cross Tab into the desired field structure:

1.PNG 

CharlieS
17 - Castor
17 - Castor

Nice work @Aaron_Harter 

MarqueeCrew
20 - Arcturus
20 - Arcturus

@national ,

 

 If you TRANSPOSE the data, Group by company then you will get:

 

Company, Name, value. 

next:  CROSS TAB and again group by company. You will set the header to Name and value to value. You need to select a method. Just select FIRST. Your data should be unique and it won't matter. 

your data should be good to go. The columns will be alphabetical and if a space occurs in the company name, it will be replaced by an underscore. 

a dynamic rename tool with a formula to replace the field Name for all underscores with a space will solve that. 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels