Forum Discussion
Can you use table structured references with a 3D reference Same column through multiple tables.
Hi All, I'm using Windows 10 home ver 20H2, 64 bit Op sys, build 19042.1052, with Excel ver 365. I want to know if its possible to use a 3D reference in a structured reference formula. I have o...
Hi L z,
I was thinking along those lines to use a Pivot table. Is Power Query the same thing or different?
I was thinking along those lines to use a Pivot table. Is Power Query the same thing or different?
Hi Debs_au
In short: Power Query & Pivot Tables are 2 different things but the first can help the second...
Not clear to me what you ultimately want to achieve. However, assuming you want to build a Pivot Table from the data in 20 Tables, in any case you need Power Query to "take" your 20 Tables and consolidate them as 1 big Table that would be the Source for your Pivot Table
Note that if you build a Pivot Table out of the Power Query query, you don't necessarily have to load the big Table on a worksheet
Hope this clarifies things a bit