Forum Discussion
thirdredwall
May 31, 2019Copper Contributor
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
- SergeiBaklanDiamond Contributor
thirdredwall , that could be done with Power Query. Please check the sample attached.
- melandiemcgeeCopper ContributorSo, how exactly did you accomplish this in Power Query?
- SergeiBaklanDiamond Contributor
Not sure I understood the question. If check step by step queries in attached to previous post file, which of them are unclear?