I have a table like this:
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>
I'm trying to come up with some VBA that would consolidate it into something like this:
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>
Any suggestions on getting me started?
Number | Trait 1 | Trait 2 | Trait 3 | Trait 4 | Trait 5 | Trait 6 |
22 | x | |||||
13 | x | |||||
45 | x | |||||
50 | x | |||||
22 | x | |||||
13 | x | |||||
45 | ||||||
50 | x | |||||
22 | x | |||||
13 | ||||||
45 | x | |||||
50 | x |
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>
I'm trying to come up with some VBA that would consolidate it into something like this:
Number | Trait 1 | Trait 2 | Trait 3 | Trait 4 | Trait 5 | Trait 6 |
22 | x | x | x | |||
13 | x | x | ||||
45 | x | x | ||||
50 | x | x | x |
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>
Any suggestions on getting me started?