Menu
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?
629
You can simple select the column, select split column from the ribbon and choose split by delimiter. Then select the space. It will create two new columns.
Ok, found it! Opened Edit queries in the data view, right click the column, Split Column > By delimiter
69
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
