How to read the excel based on upper cell

[Harish_pavuluri]

Hi to all,

I am having excel data like this
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

[ppr (Peter Preuss)]

@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:

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…

[Harish_pavuluri]

tks for reply

I will check with this.