Forum Discussion
Help with consolidation
Hi, I would like to consolidate data from several columns that have multiple rows with counts and duplicate item numbers. I have something likes this: A B C ...
My apologies, it's Office 2021 and Windows.
Here is a copy of the .xlsx. There is nothing sensitive in it, it's just a bunch of Lowe's receipts organized by date, item number, unit price and description.
There are 10 sheets in your workbook
- Which one contains the data you want to consolidate?
- Any pref. between a Power Pivot or Power Query solution?
- Whatever is the simplest to learn, haha. And Sheet 3, Columns B, C, D & E to the last row of 260. Sorry, I actually sent you the wrong sheet I had a less messy one. Thank you so much for your help!
Whatever is the simplest to learn
Just thought about an easier option that appears to work and doesn't require any learning. Wonder why I didn't think about it earlier...
- Formatted Sheet3 as Table (named Table1)
- Renamed Sheet3 as Data (for clarity)
See sheet Consolidation
Moving forward: when you add/delete/modify data in Table1, right-click somewhere in table Consolidation > Refresh