In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

transpose certain rows to columns, making data tableau ready

mkv517
6 - Meteoroid

Hi All, 

 

I have a dataset where certain demographic variables are in rows which i need in columns (input sheet). All responses should come in one column as shown in attached output sheet.

 

Grateful if you can help!

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @mkv517 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1644320997171.png

 

Hope this helps : )

 

mkv517
6 - Meteoroid

Thanks! @atcodedog05  How do i add Company ID as separate column as this is my unique identifier for each respondent?

atcodedog05
22 - Nova
22 - Nova

Hi @mkv517 

 

Where is the company id info. I can work towards it.

 

Happy to help : )

atcodedog05
22 - Nova
22 - Nova

Hi @mkv517 

 

Please find the updated workflow

 

atcodedog05_0-1644331737188.png

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @mkv517 

Cheers and have a nice day!

Labels
Top Solution Authors