Aggregate columns in table visual

[rickferreiran]

Hello
I have table like this in power bi 

But the goal this to build a visual with table like this

Does anyone know how to build this?

[adi38612]

@rickferreiran Could you find a solution to this?

[Kaviraj11 · Accepted solution]

For Power Query (M language), you can achieve a similar result by grouping rows based on a specific column and then combining the values of the other columns using the Text.Combine function. Here’s an example of how to do this:

let
    Source = YourTableName,
    GroupedRows = Table.Group(Source, {"YourGroupColumn"}, {{"CombinedColumn", each Text.Combine([YourColumnToCombine], ", "), type text}})
in
    GroupedRows