Merging a certain set of rows that matches a criteria into one single row

[SCK]

Hi All. I am trying to build a workflow that would merge a certain set of rows that matches a criteria into one single row. I have attached a dummy input and desired output. Any help would really appreciate. 

[vizAlter]

Hi @SCK — Can you please check if the files are correct? I just noticed your output file and found as below:

[SCK]

This is how I want my output to look like. It's basically the merge function in excel.

[vizAlter]

And, what about -ve values in the "Difference" column?

[SCK]

So, basically I subtracted the marks obtained from passing marks column, I can have it other way round too. Like instead of [passing marks] -[marks obtained] I can have  [marks obtained] - [passing marks] like in input file

[vizAlter]

I can have  [marks obtained] - [passing marks] like in input file

How, can +ve and -ve results could be in one single column when there is no condition; just a simple subtract?

Can you please provide us the Input file with your formulas in the "Difference" column?

[SCK]

Here, I have revised my input file to match the formula as per my output

[vizAlter]

Now, your Input.xlsx makes sense (and totally difference what you posted in the 1st post here).

[SCK]

Yeah, I got what you were saying. Is it posible to make it work?

[vizAlter]

@SCK — Here we go...