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