output

Question

any one can help how to output the below example

given file

NAMEAGESEXLOCATIONJuan23MSan Pedro

Expected Out Put

NameJuanAge23SexMLocationSan Pedro

atcodedog05 · Answer

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 : )

transpose.yxmd

danilang · Answer

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

jonick1205 · Answer

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