Return multiple names into a single cell

Hi,
I was told that my problem can be solved using a VBA, but I don’t know the first thing about VBAs and I’m an excel novice in general.
Here’s the spreadsheet I’m working with: DCM_market_update_1-15-16 test.xlsm I’m working with the columns in blue. I’m trying to consolidate the names that have an ‘X’ in their column into the corresponding cell in the ‘WMVBDs” column. For example, in the first row, there are X’s in the columns corresponding to Loop, Ramirez, and Williams. I would like those three names returned into a single cell in the WMVBDs column, with a comma in between each name.
Thanks in advance!

What about the x's under Blaylock, Drexel and Lebenthal in the same Row?

@jolivanes my code didn't work there?

@Gatti
I don't know. I was referring to Wikster7's statement of 3 x's while there were 6.

UDF

Use in cell like
=HConcatenate($U$4:$AT$4,U5:AT5,"x",", ")
and filldown.

Please Login or Register  to view this content.

Thanks jindon - this worked great!

Hi Gatti - I used jindon's solution. Thanks for trying to help me - I really appreciate it!

@jindon

That's a brilliant solution and one for my book of "who knew" :-)