Merge/Combine Rows Help

[JimmyT10]

Hello! looking for some help.

I have a sheet with over 2000 rows, some duplicates, some not. I am after a way to quickly edit the sheet to achieve a few things:

1 row entry for each unique item - combine the information (If info is present) in columns E, F, G & H for the row.

Here is what I have:

https://postimg.cc/fksFMn2R

Here is what I am trying to achieve:

https://postimg.cc/PpXRz188

Thank you so much for your help, let me know if i can provide any more information.

 

[sandy666]

try PowerQuery (Get&Transform) with Group feature and SUM option for values

 

[Sam_D_Ben]

May be something like this. You can modify the formula, just giving you an idea.

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K
1	Item No	Item Name	Item Descrptions	Category	Units on Hold		Item No	Item Name	Item Descrptions	Category	Units on Hold
2	P001	*Product 1"	Item Descrptions	Category	0		P001	*Product 1"	Item Descrptions	Category	1
3	P001	*Product 1"	Item Descrptions	Category	1		P002	*Product 2"	Item Descrptions	Category	1
4	P002	*Product 2"	Item Descrptions	Category	0
5	p002	*Product 2"	Item Descrptions	Category	1
Sheet1

Cell Formulas
Range	Formula
K2	=SUMIFS($E$2:$E$5,$B$2:$B$5,H2)

 

[Michael M]

Do the duplicates always have a zero value in cols "F" & "G" ??