Concatenate with rows and primary key type scenario?

[kate s]

I have a range of participants who all have unique identification numbers and they have taken multiple speaking series classes. These classes are listed on an excel worksheet with different rows. I want to concatenate them all together using the primary key as the unique identifier so that they are not mixed in with other attendees' results.

Example:

Identifier LName FName Speaker Series Class Address
501 Clark Evans Speaking with Heart 15 Mansion Way...
501 Clark Evans Powerful Persuasion 15 Mansion Way
550 Blake Steve Speaking with Heart 25 Anderson Avenue...
550 Blake Steve Motivational Podcasts 25 Anderson Avenue...

I have around 4,000 of these. I want it to be one ID, LName, FName, Class 1, Class 2 and Address, as below:

Identifier LName FName Speaker Series Class Address
501 Clark Evans Speaking with Heart, Powerful Persuassion 15 Mansion Way
550 Blake Steve Speaking with Heart, Motivational Podcasts 25 Anderson Avenue


By doing this, I will cut the list from 4000 rows to maybe 2500 rows. Some speakers have up to five or six classes. I'm not concerned with the size of the Speaker Series column being very wide. This is not an issue. I just have to concatenate those particular rows and get one address per person without duplicates.

Is there a way to do this without using VBA?

Thank you for your help. Much appreciated!

Kate

 

[Legacy 98055]

I'm not too sure at all that you can do this without some code. However, depending upon the arrangement of your data, maybe a pivot table? Though it would not concatenate your classes. How is your data arranged. What is in what column, etc. Is VBA not an option?