Forum Discussion
reporting comma separated values in one cell
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 t...
Use Power Query editor.
Split the column (using comma as delimiter).
Unpivot the columns that have names in them.
HotChilli
Community Champion
Community ChampionUse Power Query editor.
Split the column (using comma as delimiter).
Unpivot the columns that have names in them.