Good day,
I have the following sample data(excerpt from a large dataset) below and name it as Sheet1:
<tbody>
</tbody>
<tbody>
NO
DATE
BRAND
ORDER
MODEL
QTY
1
21/8/2019
<tbody>
CATHAY
</tbody>
<tbody>
C123456
</tbody>
<tbody>
AIRBUS
</tbody>
200
2
21/8/2019
SILKAIR...