complicated merge duplicated items with comma based on multiple columns

[abdo meghari]

hi expert
I hope finding what I look for despite of it's very complicated I have many duplicated items in COLS E,F,G in sheet1 . it should merge based on three columns together for each code in COL B and merge with comma in COL C,D based on duplicated items in COLS E,F,G . so each code in COL B end to last empty cell before start a new code . I put desired result in sheet2 with considering my data in sheet1 is increasable . current data are about 3200 rows
note: when you see stars this is actually short word JAPAN but when I use tool XL2BB it shows stars

original data in sheet1

merge.xlsm
	A	B	C	D	E	F	G	H
1	DATE	CODE	INVOICE NO	ORDER NO	BRAND	TYPE	ORIGIN	QTY
2	01/01/2021	BRS	INV1000	OR-1000	1200R20	G580	JAP	200
3	02/01/2021		INV1000	OR-1000	1200R20	G580	THI	120
4	03/01/2021		INV1000	OR-1000	1200R20	R187	JAP	100
5	04/01/2021	BRS	INV1001	OR-1001	1200R20	G580	JAP	20
6	05/01/2021		INV1002	OR-1002	1200R20	G580	THI	10
7	06/01/2021		INV1003	OR-1003	1200R20	R187	JAP	30
8	07/01/2021		INV1004	OR-1004	1200R20	R187	THI	30
9	08/01/2021	BSS	INV1005	OR-1005	195R15C	R623	JAP	10
10	09/01/2021		INV1005	OR-1005	195R15C	R623	THI	5
11	10/01/2021		INV1005	OR-1005	195R15C	R623	INDO	10
12	11/01/2021	BSS	INV1006	OR-1006	195R15C	R623	INDO	10
SHEET1

result in sheet2

merge.xlsm
	A	B	C	D	E	F	G	H
1	S.N	CODE	INV	ORD	DE	TY	OR	QTY
2	1	BRS	INV1000,1001	OR-1000,1001	1200R20	G580	JAP	220
3	2		INV1000,1002	OR-1000,1002	1200R20	G580	THI	130
4	3		INV1000,1003	OR-1000,1003	1200R20	R187	JAP	130
5	4		INV1004	OR-1004	1200R20	R187	THI	30
6	1	BSS	INV1005	OR-1005	195R15C	R623	JAP	10
7	2		INV1005	OR-1005	195R15C	R623	THI	5
8	3		INV1005,1006	OR-1005,1006	195R15C	R623	INDO	20
SHEET2

thanks

 

[C Moore]

I think Power Query is the way to go (already a part of Excel that most users don't really know about). Group By is powerful. This video explains a single column but should be expandable to handle two columns.

 

[abdo meghari]

thanks . actually I search by vba

 

[abdo meghari]

any helps?