Stacking all columns in a dataset into one column

Question

Hi Guys, I have a dataset which looks like below, but with 100 fields.

Field 1Field 2Field 3applemangoguavaorangepineapplejackfruitgrapekiwipear

I need the output to look like this.

Field 1appleorangegrapemangopineapplekiwiguavajackfruitpear

Could you please help me solve it?

Deano478 · Accepted Answer

Here is one was you can do this

ShankerV · Accepted Answer

Hi @bharathss

One way of doing this.

Note: Usage of Dynamic helps when you are having any additional columns in future will automatically get added irrespective of the count even if is greater than 100 columns.

Many thanks

Shanker V