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.

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 ...