How to read the excel based on upper cell

Hi to all,

I am having excel data like this excel data
and based on order number i have to create sale order.
if two order numbers are same I have to enter those two orders data in one sale order.
plz suggest me.
thaks to all

@Harish_pavuluri
in general we adress this case with a group by / filter on distinct order Numbers. An introduction to this topinc you can find here:

tks for reply

I will check with this.