Return to Next row in first column while using Transpose option or any other form

[Kamal GKJ]

Hi Everyone,


I am facing trouble with data for which I get list of files with specific fields. I need to scrutinize and form it in table format.


Eg
Input
Name: XXX
Age: YYY
..
Name: WWW
Age: TTT
...

Output
NAME Age
XXX YYY
WWW TTT......