Forum Discussion
Multiple Rows Data into Single Coloum
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 s...
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.
Thanks SergeiBaklan. That Helped.