Use Power Query to Split Data into Multiple Columns

Описание: Excel offers multiple ways to split data in a cell, including the venerable Text to Columns tool, Flash Fill, and writing formulas that incorporate Excel functions such as LEFT, MID, RIGHT and LEN. However, the issue with Text to Columns and Flash Fill is that you must re-run these tools when new data is added – hardly a model of efficiency! As for the for the function-based approach, the formulas you create can be tricky, depending upon the data you need to manipulate. In this tip, you will learn how you can use Power Query to split data into multiple columns.