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 DateBoroughSerialCut sizeSurnameFirst Name 16/01/2024WS2159NASKOTTERBob 16/01/2024TG7464CDMDe CRUZMaria 16/01/2024YG7464CDMDE RESLuke Merged DateBoroughSerialCut sizeSurnameFirst NameBorough2Cut size2Surname2First Name216/01/2024WS2159NASKOTTERBob 16/01/2024TG7464CDMDe CRUZMariaYGCDMDE RESLuke

Alteryx Academy
MyAlteryx
Knowledge
Help Docs

Home
Participate
Discussions
Alteryx One

Combine Rows

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