Forum Discussion

aa_KF's avatar
aa_KF
Icon for Helper I rankHelper I
7 years ago
Solved

Merge rows that have the same id number

Hello,   I have table that contains many rows for each Person, I want to merge these rows together so each person has only one row seperating the rows value using a delmiter. If the the cell conta...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Hi aa_KF 

     

    Try adding this step from the Query Editor.

    See sample file as well

     

    = Table.Group(#"Changed Type", {"ID", "Name", "Email", "Section"}, 
{
{"Course", each Text.Combine(List.Distinct(_[Course]),", ")},
{"Result", each Text.Combine(List.Distinct(_[Result]),", ")}
})

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

Hi aa_KF 

 

Try adding this step from the Query Editor.

See sample file as well

 

= Table.Group(#"Changed Type", {"ID", "Name", "Email", "Section"}, 
{
{"Course", each Text.Combine(List.Distinct(_[Course]),", ")},
{"Result", each Text.Combine(List.Distinct(_[Result]),", ")}
})

  • aa_KF's avatar
    aa_KF
    Icon for Helper I rankHelper I
    7 years ago

    Zubair_Muhammad  Thank you a lot! It's working just fine

     

    Much appreicated!! :smileyvery-happy:

  • EaglesTony's avatar
    EaglesTony
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

    I have the same issue:

     

    Here is my code based off the resolution above:

     

    = Table.Group (#"Removed Columns", {"ISSUE_KEY"},
    {
    {"TEST", each Text.Combine(List.Distinct(_[TEST]),", ")}
    })

     

    However, I get an error "Expression.Error: The column 'TEST' of the table wasn't found.

     

    But it is on my table