transpose certain rows to columns, making data tableau ready

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!

Help_Transpose.xlsx

Datasets

Preparation

Accepted answers

atcodedog05

Hi @mkv517

Please find the updated workflow

Hope this helps : )

question.yxmd

All comments

atcodedog05

Hi @mkv517

Here is how you can do it.

Workflow:

Hope this helps : )

question.yxmd

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

Hi @mkv517

Please find the updated workflow

Hope this helps : )

question.yxmd

atcodedog05

Happy to help : ) @mkv517

Cheers and have a nice day!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335