How to combine duplicated data by consolidating an entire table?

[Colin808]

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?

[#2]

@Colin808 You may use a pivot table. Invoice number in the row field and Qty in the value field.

[#3]

@Riny_van_Eekelen Thank you for your reply. Is there any other way except using a pivot table?

[#4]

@Colin808 You could just create a list of all unique invoice numbers and use the SUMIF function.