Forum Discussion
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...
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 :
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!
- Thank you very much. This explain my problem !!!