Concatenate dynamically

[daddioja]

I don't know if the title describes it, but here is what I can't figure out.

I have names of people that each choose one type of fruit. Some people choose apples, some people choose grapes, and some choose oranges. In a different part of the worksheet, I want to list each of the fruit. Next to each fruit, I want to list the names of each person who chose that fruit with a comma separating them. i don't know where to begin. Attached is a simple sample. Thanks for any help you can provide.

[teelim]

If your list is not too extensive, this should work. Else, you may have quite a tough time with repeating the CONCATENATE function.

or in place of CONCATENATE, you could use the "&" command

hope this is what you want...

[daddioja]

Thanks a bunch. I appreciate the help. I think it will work well.

[VBA Noob]

Hi,

You could miss a couple of steps with the attached

=SUBSTITUTE(TRIM(CONCATENATE(C2," ",C3," ",C4," ",C5," ",C6))," ",",")
=SUBSTITUTE(TRIM(CONCATENATE(D2," ",D3," ",D4," ",D5," ",D6))," ",",")
=SUBSTITUTE(TRIM(CONCATENATE(E2," ",E3," ",E4," ",E5," ",E6))," ",", ")

VBA Noob

[daddioja]

Thanks to you as well VBA. That is nice and tidy. I like it.

[teelim]

Thanks a bunch. I appreciate the help. I think it will work well.

Glad that I was able to help