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

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)

Hi @Shubham_Kinge ,

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

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

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.