Hopefully I can explain properly, so here goes.
In column A:C I have data in some cells while others are blank.
<colgroup><col span="2"><col></colgroup><tbody>
Red
Q30
1
Blue
2
Green
QX70
3
Yellow
QX70
3
White
FX50S
4
Purple
Q50
5
Black
FX35
6
Gray
6
White
6
Orange
6...