Combining rows if 2 values are met

[losc]

Hi there, I'm trying to combine multiple rows of answers by the same subject based on an Subject number and a certain text. For example rows 2 through 4 should be combined into a single row as their subject number and text matches, this should result in Subject 123 with the text Hello this is a test, in 2010 with times picked A = 6, B = 2, C= 3 and D = 1 in this row.

I tried doing this by creating IF formulas, but I could not figure out how to have it automatically loop to keep comparing to the row below. I also tried to write a VBA code, which works for a single row and a single column, but I cannot figure out how to make it check multiple rows and loop automatically.

Any help is greatly appreciated!