0
I have two ranges with data like this:
I want to create a Pivot Table that consolidates the data from both tables. However when I do this using ALT+D+P I end up with Country as Row label, with no way to change it's rows (the table fields only say Row, Column, Value and Page1):
What I would like to do is to have it like this (Group Cities by Country and see subtotals):
Is it possible to do this with Pivots from multiple consolidation ranges? If not is there another way to do this?
Edit
I tried doing this with microsoft query, however when I create a new sheet in my workbook, click on add data from Microsoft Query and select the same Excel I have open I get the error "Unrecognized database format". I noticed this error doesn't happen if I add another Excel file.
hi @teylyn I already tried doign this with Power Query, but it only works on my PC and I have to handle this file to different employees on my company (and I can't ask them to install Power Query). I'm now trying with microsoft query but I'm unable to add the Excel to the query, I get the error "ODBC Excel Driver Login Failed". Do you have any idea why this happens? – Lisandro Vaccaro – 2016-04-01T13:30:38.327