I'm trying to do a concatenate formula to combine all the categories from sheet 1 into one cell. The values in Sheet1 for categories would be a drop down list of blank, L, M, and H. In Sheet 2, if the category has a value, include it in part of the concatenate formula. Is an loaded IF statement the most efficient way or would a macro make more logical sense?
Sheet1:
<tbody>
</tbody>
Sheet2:
<tbody>
</tbody>
Sheet1:
ID | Category 1 | Category 2 | Category 3 | Category 4 | Category 5 | Category 6 | Category 7 | Category 8 | Category 9 | Category 10 | Category 11 | Category 12 | Category 13 | Category 14 | Category 15 |
Test1234 | M | H | L | L | M | ||||||||||
Testin511 | M | M | M | L | M | L |
<tbody>
</tbody>
Sheet2:
ID | Category Combined |
Test1234 | Area 1: Category 1 Category Value: Medium Area 2: Category 5 Category Value: High Area 3: Category 8 Category Value: Low Area 4: Category 10 Category Value: Low Area 5: Category 13 Category Value: Medium |
Testin511 | Area 1: Category 1 Category Value: Medium Area 2: Category 2 Category Value: Medium Area 3: Category 7 Category Value: Medium Area 4: Category 9 Category Value: Low Area 5: Category 11 Category Value: Medium Area 6: Category 14 Category Value: Low |
<tbody>
</tbody>