Learn how to import, clean, and transform external data in Excel using Power Query. Simplify workflows and master data analysis today ...

In this post, we will show you how to reorder multiple columns in Power Query with Drag & Drop. Often when importing data from various sources, columns may not be in the desired order.

6. Click Transform Data to launch Power Query. For now, Power Query looks empty. How to expose the Excel file’s metadata in Power Query There’s no data in Power Query, but that’s what we want.

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.