Hi,
EDIT: Attached example workbook. 3 tabs - 'Starting Point' is unprocessed. 'What I Want' is how I want the data to look when processed. 'What I Get' is what happens when I use excels consolidate tool.
I've read a few forums/webpages on this subject but none of them seem to cover my issue.
I have a list with multiple columns with text and numbers (a parts list) that has the same parts repeated throughout the list.
1.JPG
I want to consolidate this list to look this this (i.e. only sum the columns highlighted green):
2.JPG
But what I actually get is this:
3.JPG
Where ALL the columns are being summed and the text disappears.
Can anyone tell me if there is an easier way of doing this than manual going through adding up the quantities and the deleting the duplicates?
Thanks,
Luke.
Bookmarks