Combine Rows

[berty]

Hello, 

I'm having a issue where i cant seem to merge rows of data,  i have a large dataset with multiple rows i just need to merge the data where the serial matches... any idea how i can do this?

Data
Date	Borough	Serial	Cut size	Surname	First Name
16/01/2024	WS	2159	NAS	KOTTER	Bob
16/01/2024	TG	7464	CDM	De CRUZ	Maria
16/01/2024	YG	7464	CDM	DE RES	Luke
Merged
Date	Borough	Serial	Cut size	Surname	First Name	Borough2	Cut size2	Surname2	First Name2
16/01/2024	WS	2159	NAS	KOTTER	Bob
16/01/2024	TG	7464	CDM	De CRUZ	Maria	YG	CDM	DE RES	Luke

[wbroughton]

@berty Have you tried using the Join tool and join by the specific field "Serial"? 

[MilindG · Accepted solution]

@berty