Forum Discussion
HeartFragile
Feb 16, 2019Copper Contributor
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...
SergeiBaklan
Feb 16, 2019Diamond Contributor
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.
- HeartFragileFeb 18, 2019Copper Contributor
Thanks SergeiBaklan. That Helped.