- last edited on
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:
@thirdredwall , that could be done with Power Query. Please check the sample attached.