Convert data (a bit like a FOREACH?)

[simonp820]

Hello,

Keen Excel user here trying to do something a little bit out of his skill set!

I have a spreadsheet with the info below. Every person will sign up for swimming (23442) but they can then optionally sign up for UP TO 7 other sports. If they have signed up for something else then there will be another entry in the spreadsheet.

event	userid	username	firstname	lastname
23442	651	philly	Phil	Smith
23442	673	wibblewo	David	James
23442	876	slimtony	Tony	Wilson
23442	1617	fatboy	Dave	Dee
29033	1617	fatboy	Dave	Dee
28985	1617	fatboy	Dave	Dee
23442	1877	alanantic	Alan	Bob
28973	1877	alanantic	Alan	Bob
28838	1877	alanantic	Alan	Bob
23442	2074	jamesbob	Jayme	Mayer
23442	9944	Chester	Will	Black
29201	9944	Chester	Will	Black
28976	9944	Chester	Will	Black
29273	9944	Chester	Will	Black

I need to change the above so that each person is only on one line - something like:

userid	username	firstname	lastname	event codes
651	philly	Phil	Smith	23442
673	wibblewo	David	James	23442
876	slimtony	Tony	Wilson	23442
1617	fatboy	Dave	Dee	23442, 29033, 28985
1877	alanantic	Alan	Bob	23442, 28973, 28838
2074	jamesbob	Jayme	Mayer	23442
9944	Chester	Will	Black	23442, 29201, 28976, 29273

Any help gratefully appreciated! I'm certain I can do it but it's driving me bonkers!

Thanks