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>
A
B
C
D
</thead><tbody>
1
Title1
Title2
Title3 [Height]
Title4
2
BA...