reporting comma separated values in one cell

[Anonymous]

Hello,

the column has comma separated text i.e. paul, robert, sarah...

In my table visual, I would like to have one row per separated comma i.e

data

------

paul

robert

sarah

how can I do this please? may be in DAX?

Thank you

[HotChilli · Accepted solution]

Use Power Query editor.

Split the column (using comma as delimiter).

Unpivot the columns that have names in them.