Combine rows with same data and sum data

[EvansRJ]

Good Afternoon,

Can someone please tell me how to combine the following data...

Issue Type	Shipment Type	Count Closed	Count Open
User	PO	33	9
User	PO	0	1
User	PO	1	1
User	PO	23	2
User	PO	34	0

Assuming Rows 1-6 and Columns A-D, how to I get a result where it combines the columns with the same name (A&B) and sums columns C&D. So the final result would be this...

User

PO

91

13

Thank you!

 

[sandy666]

Microsoft OneDrive