Forum Discussion

Copper Contributor

Dec 02, 2021

Combine two matrix one under the other

Hi, I have two tables : [Group_A], [Group_B]. I want to put all the data of each other in one table. I want to use formulas because each table might grow over the time. The purpose is to analyse the...

Example.xlsx14 KB

excel

Riny_van_Eekelen

Platinum Contributor

Dec 02, 2021

leolo7 Consider using Power Query. Query both tables and Append them into a third that you load back to Excel. Just keep on adding data to the tables, press Refresh All on the data ribbon and you're done. Demonstrated in the attached file.

If you are new to PQ, the link below could be a good starting point.

https://exceloffthegrid.com/power-query-introduction/

Chapter 8 deals with combining and appending queries.

Example_groupingPQ.xlsx22 KB

leolo7

Copper Contributor

Dec 02, 2021

Riny_van_Eekelen Thanks for your fast response and solution. I'm not familiar with Power Query. The solution is probably in "Get Data..". however, I don't have this in my menu. I have the latest version of Excel for Mac (16.55), Microsoft 365. Any setting I should change?

Thanks!

I find this on Microsoft web site (for Mac) :

This is what I have :

Riny_van_Eekelen
Platinum Contributor
Dec 02, 2021
leolo7 Oh my! You're on a Mac. Excel for Mac doesn't support Power Query in the way I used it. Then you'll need VBA which isn't really my thing. Sorry!
- leolo7
  Copper Contributor
  Dec 02, 2021
  Thank you very much. This explain my problem !!!