Sunmarize list

[besttt]

Hello, I need help summarize list on people ordering which items. I currently have 50 lists of items and more than 100 people. I’ve done most of the part but it’d be nice if I can show which person order which item and how many in a different sheet. Please do help me.Thank you

 

[DanteAmor]

Hi and welcome to MrExcel.

Do persons already exist on the destination sheet? Or is the sheet empty?
Can it be with a macro or do you want formulas?

 

[CA_Punit]

Book1
	A	B	C
1	Column1	Attribute	Value
2	Person 1	A	1
3	Person 1	D	2
4	Person 2	B	1
5	Person 2	E	1
6	Person 3	B	1
7	Person 3	D	1
8	Person 4	C	2
9	Person 4	E	1
Sheet4

Will this suffice your requirement