We have a excel data with multiple blank rows but having one value in each row which we have to add it under first row

[Shubham_Kinge]

Lets consider we are having this type of input data

Now in this data we need to remove the blank rows and value column should contains all values from marks which are spread on below rows. Please see the attached output .

For this i have made a code. you can go through it. here is the package.
DManupulation.zip (10.9 KB)

[supermanPunch (Arpan)]

Hi @Shubham_Kinge ,

I believe firstly, we would need to perform a Fill Up as mentioned in the below post :

How to match data between 3 columns

when readin int the excel into a datatable (read range) we would expect following result Group1|1|true |2|True … so we would filling up the missing GroupX column values grouping the data on GroupDocs processing / evaluating the groups For filling up, have a starter help here: FillUp_BlockBlanks.xaml (9.3 KB) Grouping data have alook here:

Then, we can perform a GroupBy on the 3 Columns and generate the Output by Concatenating the Grouped Rows.

[Shubham_Kinge]

Thank you for letting me know. I not found any related post that’s why posted. Thank you @supermanPunch

[ppr (Peter Preuss)]

@Shubham_Kinge

I not found any related post

[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…