This editor makes it possible to perform numerous data processing operations that were previously carried out by macros that were slow to program and inflexible.

For example, you can :

• Rearrange rows and columns
• Delete missing values
• Filter rows
• Use the first row as a header
• Merge, split or group columns
• And much, much more!

Once this treatment has been defined, the data is converted directly into a table, ready to be used for pivot tables!

What’s more, once the query has been run, it can be saved and reused many times, just like a macro. However, no knowledge of VBA is required for this tool.

It is therefore possible to completely automate the data processing workflow by combining different queries.

One of the final advantages of PowerQuery is that it doesn’t weigh down your Excel file. In fact, it simply imports data from different sources and transforms it without recopying it in its entirety. This option means you can work with databases containing several million lines!

IF you are planning to use PowerQuery with your database, we recommend that you organise your database properly beforehand to avoid unnecessary effort. To do this, take a look at our article: SQL Tutorial : TOP 5 most useful functions