Alteryx Workflow - convert a set of columns into rows

[KowsalyaSriram_30]

Hello,

I am trying to format the attached input file and bring the Main account data to each line. I attached manual output file too.. Can any one please assist me with the workflow. 

any help would be much appreciated! thanks.

[Emmanuel_G]

Hi @KowsalyaSriram_30 ,

Find attached one way to achieve to this result.

[KowsalyaSriram_30]

Hi Emmanuel - Thank you so much. Can you please send me the ASCII field setting as well to import the format to input file. 

[Emmanuel_G]

Is it what you want ? @KowsalyaSriram_30 

[Emmanuel_G]

@KowsalyaSriram_30 

Was that what you want ?