Multiple Rows Data into Single Coloum

[HeartFragile]

Dear Experts.

I have sequential Data in a Table. Need a Logic to have these Table date in one Single Coloum.

A2 B2 C2

A3 B3 C3

A4 B4 C4

Result in Coloum D to be as 

A2

B2

C2

A3

B3

C3

so on .......

Please advise. Attached Sample.

Expert Advise Please. Thanks in Advance.

[#2]

Hi,

That could be done with Power Query - query your range, select all columns, unpivot them and land result into Excel worksheet.

Please check attached.

[#3]

Thanks @Sergei Baklan. That Helped. 

[#4]

Hi @HeartFragile, I Think you can you Synkronizer Excel Add-in. Using Synkronizer you Don't need to write any code or Excel formula, Just Download Synkronizer and add into Excel Add-in then and use it.