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 ...
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!
- 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