Forum Discussion
Moving Data from Columns to Rows
Help! before I do manual keying of data, I wanted to ask this question. Not sure thIs is possible; is there a way to move data from two columns into the rows. I tried Transpose function and a few o...
rlight1959 I suspect that your real data contains many more rows and maybe not all groups of names contain 4 rows. Or perhaps, the names aren't even sorted to begin with. If so, then you may want to consider Power Query. The attached workbook contains an example. Perhaps you find it a helpful alternative.