Forum Discussion
How to combine duplicated data by consolidating an entire table?
Hi, I'm trying to consolidate a table that contains some duplicated data. What I'd like to do is to combine all duplicated Invoice No. by consolidating them, so I can see sum qty of each Invoice No.
Can anyone advise how I can combine some duplicated Invoice No. by using a consolidate function?
or is there any other way that I can combine duplicated data?
3 Replies
Colin808 You may use a pivot table. Invoice number in the row field and Qty in the value field.
Riny_van_Eekelen Thank you for your reply. Is there any other way except using a pivot table?
Colin808 You could just create a list of all unique invoice numbers and use the SUMIF function.
