Split Table Type Value by comma in single row

[Anonymous]

Hi,

Can anyone help me with this, please?

I have a column MCRType of type Table. The 5th row contains these values.

My requirement is I want those values to be comma-separated, but the split column in the power query editor is disabled for the MCRType column.

[HotChilli]

If i understand correctly you want to convert the table to a text field separated by commas.

So, add a custom column to create a list.  This will be [MCRType][Value] . Then you can expand the list from the column header to extract values (choose comma as delimiter).

[Anonymous · Accepted solution]

Thanks, @HotChilli  for the reply.

So I created a custom column and wrote the code below and the new column got converted to list and I was able to extract values.