Merge duplicate row values from sheet 1 to sheet 2 with macro

[bahrami]

Hi, I would like to thank you for integrating and merging duplicate and non-duplicate row values from sheet 1 to sheet 2.

Example file-01 - Copy.xlsm
	A	B	C	D	E	F	G	H
1	Row	National Code	name	last name	Union name	Election period	titel	Election date
2	1	181-842934-9	Sasan	Bahrami	Tools Union	first period	chief	1391/03/27
3	2	181-842934-9	Sasan	Bahrami	Tools Union	second period	chief	1395/02/26
4	3	181-842934-9	Sasan	Bahrami	Tools Union	second period	chief	1399/02/26
5	4	181-987654-3	Amir	Bahrami	Electric Trade Union	Third period	Deputy	1395/02/26
6	5	181-987654-4	Amir	Bahrami	Electric Trade Union	Fourth period	Deputy	1400/02/31
Sheet1

Example file-01 - Copy.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Row	National Code	Name	Last name	Union name	first period		second period		Third period		Fourth period		Number of periods of participation in elections
2						titel	Election Date	titel	Election Date	titel	Election Date	titel	Election Date
3	1	181-842934-9	Sasan	Bahrami	Tools Union	chief	1391/03/27	chief	1395/02/26	chief	1399/02/26	0	0	3
4	2	181-987654-3	Amir	Bahrami	Electric Trade Union	0	0	0	0	Deputy	1395/02/26	Deputy	1400/02/31	2
Sheet2