Home

Converting single rows into multiple duplicate rows w/multiple columns

%3CLINGO-SUB%20id%3D%22lingo-sub-661225%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20single%20rows%20into%20multiple%20duplicate%20rows%20w%2Fmultiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-661225%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F352567%22%20target%3D%22_blank%22%3E%40thirdredwall%3C%2FA%3E%26nbsp%3B%2C%20that%20could%20be%20done%20with%20Power%20Query.%20Please%20check%20the%20sample%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-660737%22%20slang%3D%22en-US%22%3EConverting%20single%20rows%20into%20multiple%20duplicate%20rows%20w%2Fmultiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-660737%22%20slang%3D%22en-US%22%3E%3CP%3ENeed%20to%26nbsp%3Bconvert%20data%20for%20a%20single%26nbsp%3Bperson%20on%20one%20row%20with%20multiple%26nbsp%3Bcolumns%20into%20multiple%20rows%20for%20the%20same%20person%20plus%20each%20column%20of%20related%20data.%20Transpose%20does%20not%20work.%20Power%20Query%20might%20do%20the%20trick%2C%20but%20this%20is%20the%20first%20time%20using%20that%20tool.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20much%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20sample%20data%20to%20start%20with%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20932px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116724i9694AD480C8AD845%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Start%20Table.JPG%22%20title%3D%22Start%20Table.JPG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EExisting%20table%20of%20data%3C%2FSPAN%3E%3C%2FSPAN%3EConvert%20to%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20336px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116725i5CBD6D94D62F896E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22End%20Table.JPG%22%20title%3D%22End%20Table.JPG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFinal%20Result%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-660737%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Query%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
thirdredwall
Occasional Visitor

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:

Start Table.JPGExisting table of dataConvert to:

End Table.JPGFinal Result

1 Reply

@thirdredwall , that could be done with Power Query. Please check the sample attached.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies