Based on column B data value, copy column A data in C and D column. Only highest no related sub-data will go in C column. Rest will go in D.
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
A | B | C | D | |
---|---|---|---|---|
1 | Title1 | Title2 | Title3 [Height] | Title4 |
2 | BA Drom 10AB DRAG CAC ISO B3A PK 344 M | 5.777327 3.479375 15.58231 5.201591 4.01268 | CAC ISO | BA Drom, 10AB DRAG, B3A PK, 344 M |
3 | ||||
4 | BA Drom 10AB DRAG kak1 ISO B3A PK 34M4 M | 5.777327 3.479375 15.58231 15.58231 4.01268 | kak1 ISO, B3A PK | BA Drom, 10AB DRAG, 34M4 M |
5 | ||||
6 | ||||
7 | ||||
8 | BA Drom 10AB DRAG CAC ISO B3A PK 34M4 M | 5.777327 3.479375 15.58231 5.201591 4.01268 | CAC ISO | BA Drom, 10AB DRAG, B3A PK, 34M4 M |
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1