Hello, I need some macro who can make from this table :
<colgroup><col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:7606;width:156pt" width="208"> <col style="width:48pt" width="64" span="7"> </colgroup><tbody>
</tbody>
into this :
<colgroup><col span="2"><col><col span="7"></colgroup><tbody>
</tbody>
It basically needs to merge rows with the same number in the first column together, but do not count the values together, when there are multiple in the same column
Thanks for help
9 | X | xxx | 1 | 1,00 € | |||||
9 | X | xxx | 2 | 2,00 € | |||||
9 | X | xxx | 3 | 3,00 € | |||||
10 | Y | yyy | 1 | 1,00 € | | ||||
10 | Y | yyy | 2 | 2,00 € | |||||
10 | Y | yyy | 3 | 3,00 € | |||||
10 | Y | yyy | 4 | 4,00 € |
<colgroup><col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:7606;width:156pt" width="208"> <col style="width:48pt" width="64" span="7"> </colgroup><tbody>
</tbody>
into this :
9 | X | xxx | 1 | 2 | 3 | 1,00 € | 2,00 € | 3,00 € | |
10 | Y | yyy | 1 | 2 | 3 | 1,00 € | 2,00 € | 3,00 € | |
10 | Y | yyy | 4 | 4,00 € |
<colgroup><col span="2"><col><col span="7"></colgroup><tbody>
</tbody>
It basically needs to merge rows with the same number in the first column together, but do not count the values together, when there are multiple in the same column
Thanks for help