If you are working with Excel spreadsheets or workbooks, juggling multiple tables of data, at some time you might need to combine them into one. Rather ...

Then, use the drop-down menus to select the tables you want to append. When you click "OK," the Power Query Editor reopens with the selected tables appended.

Learn how Power Query, Power Pivot, and VBA can transform your Excel skills. Choose the right tool and boost your productivity today.

I've written many times about the many benefits of formatting your data as a structured table in Microsoft Excel. However, despite this, there's one major issue that continues to throw a spanner ...