Forum Discussion
Split Table Type Value by comma in single row
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.
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.
2 Replies
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).
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.
