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 tr...
BI & Data Analytics
Power Query
  • melandiemcgee's avatar
    melandiemcgee
    Copper Contributor
    Jul 29, 2021
    So, how exactly did you accomplish this in Power Query? 
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jul 29, 2021

      melandiemcgee 

      Not sure I understood the question. If check step by step queries in attached to previous post file, which of them are unclear?

      • melandiemcgee's avatar
        melandiemcgee
        Copper Contributor
        Jul 29, 2021

        Sorry. I don't have a background in Power Query. But I need to accomplish what you've done here. I see the query steps listed in the attachment but I don't know where to start to replicate what you've done. I guess I am looking for a step by step on the process--the details of what you did for each query step.

         

        I have the data in an excel file and I know how to launch the power query editor. From there, I don't really know what to do. What I am looking to do is duplicate id's and create multiple rows for each test score (see attachment). This might be the wrong forum for that kind of assistance. If so, my apologies. But, any help you can provide would be appreciated.

        SergeiBaklan 

Resources