Another way to split data into multiple columns is to use some of Microsoft Excel's functions. If you choose this route, remember that the split values will be linked to the original values, meaning ...

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

I have a table that stores a comma separated list of key value pairs for permissions. E.g 45:902,45:61,51:203,51:208 etc. I'm trying to parse a single record row so that I get a record set of ...

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.