Summarize checked columns

[azbycx]

I have a data table where certain properties are listed at the top, and a list of drawing numbers is on the left. For each drawing number, 3 to 5 of the properties are selected or "checked" (cell intersection is marked with an "x"). I'd like to summarize the checked characteristics at the end of the line.

Here's a simple example:

.....APPLES..BANANAS..CHERRIES
ADAM...X.......X................APPLES, BANANAS
BETH...........X.........X......BANANAS, CHERRIES
CARA...X........................APPLES
DANE.....................X......CHERRIES

The result at the right is what I need -- a summary of the checked items. However, consider that my list is 300 rows and 50 columns, so I will need something more general than just [if B2="x" then "apples", if C2="x" then "bananas"...].

Thanks.

 

[Andrew Poulsom]

You could use Chip Pearson's StringConcat function:

http://www.cpearson.com/Excel/stringconcatenation.aspx

 

[azbycx]

Chip Pearson's StringConcat user-defined function worked exactly as I wanted. Thanks very much for your help!

For reference, here is how I applied it based on my previous example (entered as an array formula using CTRL SHIFT ENTER):

=StringConcat(", ",IF(B2:D2="x",B$1:D$1,""))
​