Stacking all columns in a dataset into one column

[bharathss]

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

Field 1	Field 2	Field 3
apple	mango	guava
orange	pineapple	jackfruit
grape	kiwi	pear

I need the output to look like this.

Field 1

apple

orange

grape

mango

pineapple

kiwi

guava

jackfruit

pear

Could you please help me solve it?

[Deano478 · Accepted solution]

Here is one was you can do this 

[ShankerV · Accepted solution]

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

[bharathss]

thanks guys, both your solutions helped me!

[Deano478]

@bharathss No problem at all happy to help