Multiple Rows Data into Single Coloum

Question

Dear Experts.I have sequential Data in a Table. Need a Logic to have these Table date in one Single Coloum.A2 B2 C2A3 B3 C3A4 B4 C4&nbsp;Result in Coloum D to be as&nbsp;A2B2C2A3B3C3so on .......Please advise. Attached Sample.&nbsp;Expert Advise Please. Thanks in Advance.

sergeibaklan · Answer

Hi,
&nbsp;
That could be done with Power Query - query your range, select all columns, unpivot them and land result into Excel worksheet.
&nbsp;
Please check attached.

heartfragile · Answer

Thanks SergeiBaklan. That Helped.&nbsp;

synkronizerexcelcomparetool · Answer

Hi&nbsp;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.&nbsp;

Forum Discussion

Multiple Rows Data into Single Coloum

3 Replies

Resources