output

[jonick1205]

any one can help how to output the below example

given file 

NAME	AGE	SEX	LOCATION
Juan	23	M	San Pedro

Expected Out Put

Name	Juan
Age	23
Sex	M
Location	San Pedro

[atcodedog05]

Hi @jonick1205 

This can be done using the transpose tool. Refer to below screenshot.

Workflow:

Reference resource: https://community.alteryx.com/t5/Interactive-Lessons/Changing-Data-Layouts/ta-p/82876 

Hope this helps : )

[jonick1205]

Thank you but i have a follow up question, What if i have multiple set how can i separate the other record?

[danilang]

Hi @jonick1205 

If you have multiple records, add a RecordID tool before the transpose and include the recordID as a Key Column in the Transpose tool configuration

Dan

[atcodedog05]

Hi @jonick1205 

Has @danilang mentioned you can use the record id tool to set row id. And transpose with keeping row id as key for reference.

Hope this helps : )