Merge rows that have the same id number

[aa_KF]

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 contains duplication it suppose to hide it and show the values with no duplication. 

Original Table:

Desired Table:

Thank you and appreicate your help!

[Zubair_Muhammad · Accepted solution]

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]),", ")}
})

[EaglesTony]

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

[aa_KF]

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

Much appreicated!!