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
