CODEWITHSUNDEEP
powerbi
R0b0tn1k
R0b0tn1k

Reputation: 4306

PowerBI: Split column in to separate columns

I have a category multiselect field which i'm importing, which has multiple values separated by a comma:

Agriculture, Microfinance, Peace Building

My primary instinct is to split each value in to a separate column using text functions, but i'm wondering if there's a better, easier way of doing this?

Upvotes: 5

Views: 18800

Answers (1)

R0b0tn1k
R0b0tn1k

Reputation: 4306

Ok, found it! Opened Edit queries in the data view, right click the column, Split Column > By delimiter

Upvotes: 7

Related Questions