Transform Headers into rows - cross tab

Question

Hi Team,

I have the input dataset in below format and need the desired output.

Input:-

nameabcage10roll no 1subeng

Output:-

nameageroll no subabc101eng

Could you please help me on the same :)

Many Thanks in advance!!

gawa · Accepted Answer

@sneha_bhiwagade1

If your data always have the same schema, it's worth of trying the Arrange tool.

By doing so, input data will be piled vertically so the Cross-tab tool can be directly applied.

Raj · Accepted Answer

@sneha_bhiwagade1 if you are having the data always in same format then 
arrange tool will work best else there will be a requirement on the new logic.

gawa · Accepted Answer

@sneha_bhiwagade1

I think your input data is MS Excel or CSV then you can utilize option of "First Row Contains Data" and/or "Start Data Import Line" in the Input tool to adjust header. Good luck!