Forum Discussion
Transpose Multiple Rows Into Single, Concatenated Column
I want to transpose multiple items out of multiple rows into a single, concatenated column. For instance, starting with... CA CB CC CD R1 X 1 2 3 R2 Y 4 5 6 ...
No more than 200 rows and 35 columns.
have you tried power query and unpivoting other columns starting with columns CB then add an index column after unpivoting the other columns? I tried it but merging the R's with the index numbers yeilds the numbers before the letter so it looks like 1R instead of R1 so you'll have to do the left([column],1)&[index column] after you close and load