Combining multiple column data to one column

[Gsiva3]

Hi Team,

In a input file I have column named A,B,C,D,E. My purpose is to combine all these columns into a single column in a standard manner, like content of column A at top followed by content B,C,D,E in a single column.

is there any possibility to do this so?

I have attached the input & desired output

[atcodedog05 · Accepted solution]

Hi @Gsiva3 

Here is how you can do it.

Workflow:

Hope this helps : )

[Gsiva3 · Accepted solution]

Hi @atcodedog05 

It works fine👍

[atcodedog05]

Happy to help : ) @Gsiva3 

Cheers and have a nice day!

[Gsiva3]

Hi @atcodedog05 

Sorry for asking it again,

If I have column number A as 1st column, D as 2nd column & B as 3rd Column,

Now I want A column value at top and then column D which is followed by column B.

Is it possible to do it in this manner. sorting not based on column name based on column position.

[atcodedog05 · Accepted solution]

Hi @Gsiva3 

Here is how you can do it.

Workflow:

Hope this helps : )

[Gsiva3]

Thanks @atcodedog05