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.

Step 3: Transform the Data in the Power Query Editor Before you load the appended data back into your Excel workbook, make any necessary adjustments to the data's structure.