How to convert rows to comma separated values in Power BI

Aditya.Somwanshi
2 min readDec 8, 2021

--

In this blog, we will see how we can convert rows into comma-separated values in single rows using Power BI.

Step 1:

Import your table and go to transform data and remove empty or null rows if any.

Step 2: In-home section go to group by

Step 3: Group the table with the user column and select all rows in operation, give a name to your new column.

Step 4: Now go to the custom column section from add columns.

Step 5: Write the following query in the editor.

Table.Column( aggregate column name,”original column name”)

Step 6:

Hit ok and click on expand button and select extract values.

Step 7:

You can select the delimiter from the drop-down, here I have selected custom.

You can delete that aggregate column that was created before if you want to.

In this way, you can convert rows to comma-separated values in Power BI

--

--