Reorder multiple columns with Drag & Drop. Once the data is open in the Power Query Editor, hold the Ctrl key and select the desired columns in the order you want them to be displayed. For example ...

Microsoft Power Query showed up in Excel 2016, though earlier versions can access Power Query using an add-in. ... Power Query adds the new column. We’ll add the month to each data set that we add.

When this is the case, you can use Power Query’s Extract and Split Column features to extract delimited strings into their components. I’m using Microsoft 365 Desktop and Power Query in ...