Convert data (a bit like a FOREACH?)

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.

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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

Thanks

Oh walruseggman that's just awesome! I remember doing VB stuff years ago and that all makes sense - I've just never applied it to Excel and look forward to learning more.

The code works great - thank you so much!

OK I tried to do the event name lookup but failed miserably

If I had another sheet ("events")with the event IDs/event names in, how would I alter the above code to replace the event IDs with the event name?

So the "events" sheet would be simply:

Please Login or Register  to view this content.

I've been reading about VLOOKUP but can't work out how to integrate it with the above code.

Any help welcome!

Thanks again walruseggman - just perfect