Hi,
So my table for example looks like this:
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
I would like it to look like:
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
I was trying to use offset, indirect.. and got confused. I feel like this is simple but I just don't know how to do it. I still can't do this in reverse either haha.
So my table for example looks like this:
Empl_ID | A2 | A3 | A4 |
11111 | 1 | 8 | 9 |
14044 | 2 | 9 | 9 |
14070 | 3 | 2 | 9 |
14167 | 4 | 2 | 9 |
14199 | 5 | 4 | 9 |
14210 | 6 | 7 | 9 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
I would like it to look like:
1111 | 1 | A2 | |
1111 | 8 | A3 | |
1111 | 9 | A4 | |
14044 | 2 | A2 | |
14044 | 9 | A3 | |
14044 | 9 | A4 | |
14070 | 3 | A2 | |
14070 | 2 | A3 | |
14070 | 9 | A4 | |
14167 | 4 | A2 | |
14167 | 2 | A3 | |
14167 | 9 | A4 | |
14199 | 5 | A2 | |
14199 | 4 | A3 | |
14199 | 9 | A4 | |
14210 | 6 | A2 | |
14210 | 7 | A3 | |
14210 | 9 | A4 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
I was trying to use offset, indirect.. and got confused. I feel like this is simple but I just don't know how to do it. I still can't do this in reverse either haha.