Trick 003 Merge tables excel with Power query

You can merge (combine) rows from one table into another simply by pasting the data in the first empty cells below the target table. But with but with complex data we can’t do that. With power query you can do this easily.

When it comes to joining tables in Power Query we have many ways to do it. In this example, I made 2 relatively complex tables with 2 different options.

Originally published at https://www.clubdiscuss.com on April 16, 2023.