Data
Pivot raw exports
Join two exports and summarise them the way you would in a pivot table.
Fill it in
The files to combine.
The column they share.
What you want broken down by what.
An .xlsx rather than a table in chat.
Your prompt
Combine the exports in and summarise them. Join on [your join on]. [your summarise] Check the join before trusting anything downstream. Report how many rows matched, how many did not, and what the unmatched ones have in common: a join that quietly drops 12% of the data produces a summary that is confidently wrong, and the numbers still add up. Normalise the keys first. Trailing spaces, different cases and a leading apostrophe from Excel are why an obvious join fails. Deliver an .xlsx: one sheet per breakdown, plus the joined rows so the numbers can be traced back.
Continue and pick your folderOpens with everything above already filled in.
Why this works
A join that quietly drops 12% of the rows produces a summary that is confidently wrong and still adds up. This reports what matched, what did not, and what the unmatched rows have in common, after normalising the keys so an obvious join stops failing on trailing spaces.
Questions
- More than two files?
- Yes, point it at a folder.