Forum Discussion

thirdredwall's avatar
thirdredwall
Copper Contributor
May 31, 2019

Converting single rows into multiple duplicate rows w/multiple columns

Need to convert data for a single person on one row with multiple columns into multiple rows for the same person plus each column of related data. Transpose does not work. Power Query might do the trick, but this is the first time using that tool.

 

Any help is much appreciated!

 

Here is the sample data to start with:

Existing table of dataConvert to:

Final Result

9 Replies

Resources