Forum Discussion

C9SA's avatar
C9SA
Frequent Visitor
5 years ago
Solved

Create a list with Power Query and apply List.Mode

Hi all,   For example I have a column "Colours" which holds values and are separated by a comma:   Product Colours List List.Mode A Green, Red, Green, Cyan, Blue, Yellow, Orange, Orange...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can add a custom column in the query editor and use Text.Split([Coulors], ",") to get a column of lists.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

You can add a custom column in the query editor and use Text.Split([Coulors], ",") to get a column of lists.

Regards,

Pat

  • C9SA's avatar
    C9SA
    Frequent Visitor
    5 years ago

    Thanks!