Forum Discussion

madluolis's avatar
madluolis
New Member
4 years ago
Solved

Column with comma separated values to list

Seeking for kind help in respect a problem which I have, I have next table, which contains two columns, one with comma separated values:   Name | Country Maria | Spain, Portugal, Italy P...
  • pfarias's avatar
    4 years ago

    You can add a new column using the Text.Split function as in the example:

     

    =Text.Split([Country], ",")

     

     

    A new column of type List will be created. Then just expand it.