Rows to List

[StoryofData]

Hello, 

How do I convert my table into a list based on selected values?

This is what I have 

Identification Number	Category	All Other columns
A-123	Apple
A-123	Mango
A-123	Banana
B-456	Pineapple
B-456	Watermelon

What I need

Identification Number	Category
A-123	Apple, Mango, Banana
B-456	Pineapple, Watermelon

[vicky_ · Accepted solution]

If this is in DAX, you can use the CONCATENATEX function to combine; something like:

CategoryCombined = CONCATENATEX(CALCULATETABLE('Table', ALLEXCEPT('Table', 'Table'[Identification Number])), 'Table'[Category], ", ")

[StoryofData]

thank you so much!