Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

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.

You can easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to unhide all hidden cells.