Good day everyone. I could use some guidance. I have table that is used for people to pick dates they want to volunteer their time for. I need to translate the date
from
<tbody>
</tbody>
to
<colgroup><col style="width:48pt" width="64" span="5"> </colgroup><tbody>
</tbody>
I am looking for a dynamic formula for the "TO" table. Any thoughts?
D
from
Date 1 | Date 2 | Date 3 | Date 4 | Date 5 | Date 6 | |
Bob | x | x | x | |||
Sue | x | x | x | |||
John | x | x | x | |||
Frank | x | x | x | |||
Mary | x | x | x | |||
Gail | x | x | x | |||
Keith | x | x | x | |||
Glenda | x | x | x |
<tbody>
</tbody>
to
Person 1 | Person 2 | Person 3 | Person 4 | |
Date 1 | Sue | Frank | Gail | Glenda |
Date 2 | | |||
Date 3 | | |||
Date 4 | | |||
Date 5 | | | ||
Date 6 |
<colgroup><col style="width:48pt" width="64" span="5"> </colgroup><tbody>
</tbody>
I am looking for a dynamic formula for the "TO" table. Any thoughts?
D