rjbinney
Active Member
- Joined
- Dec 20, 2010
- Messages
- 264
- Office Version
-
- 365
- Platform
-
- Windows
I have a table with a long list of items, followed by multiple columns of potential "attributes" for that list. The attributes are ticked either on or off.
<tbody>
</tbody>
I'd like to be able to make a list that concatenates JUST the ticked attributes
<tbody>
</tbody>
So I built a second table, essentially:
=IF (ISBLANK (B2),"",", B$1)
Which gives me
A | B | C | D | E | F | G | H | |
1 | Organic | Juicy | Delicious | Deadly | Seeds | Carbon-Based | Carbon Steel | |
2 | Apples | x | x | x | x | x | ||
3 | Oranges | x | x | x | x | |||
4 | Muskrats | x | x | x | x | |||
5 | Muskets | x | x |
<tbody>
</tbody>
I'd like to be able to make a list that concatenates JUST the ticked attributes
Apples | Organic, Juicy, Delicious, Seeds, Carbon-Based | |
Oranges | Organic, Juicy, Delicious, Carbon-Based | |
Muskrats | Organic, Delicious, Deadly, Carbon-Based | |
Muskets | Deadly, Carbon Steel |
<tbody>
</tbody>
So I built a second table, essentially:
=IF (ISBLANK (B2),"",", B$1)
Which gives me
J | K | L | M | N | O | P | |
1 | Organic | Juicy | Delicious | Seeds | Carbon-Based |