You can split data by selecting the column containing the data you want to split and then using the ‘Split Column’ option from the ‘Transform’ tab in the Power Query Editor.

A super easy way to generate new records from multi-value columns using Excel Power Query Your email has been sent Have a complex Excel problem? Power Query to the rescue! Analyzing data often ...

Excel's Power Query Editor also has the capacity to import and organize data from external sources, like a PDF, a website, or another spreadsheet. Getting into the habit of using this powerful ...

This month’s column shows how to clean and join data using Excel’s Power Query.