transpose certain rows to columns, making data tableau ready

[mkv517]

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!

[atcodedog05]

Hi @mkv517 

Here is how you can do it.

Workflow:

Hope this helps : )

[mkv517]

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

[atcodedog05]

Hi @mkv517 

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

Happy to help : )

[atcodedog05 · Accepted solution]

Hi @mkv517 

Please find the updated workflow

Hope this helps : )

[atcodedog05]

Happy to help : ) @mkv517 

Cheers and have a nice day!