Forum Discussion
aa_KF
Helper I
Helper IMerge 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...
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
Community Champion
Community ChampionHi 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]),", ")}
})