Combine 2 Rows of Data If Conditions are Met

Hi
I was wondering if there is a way of combining 2 rows of data if certain conditions are met. I have attached an example of my worksheet for reference.

Example.xlsx

What I want to happen is if a number in column J is followed by an "x" then it should be combined with the row of the same number (e.g. 236x should be combined with 236, 237x with 237 etc.). However, the only 2 values which need to be combined are columns AQ and AR.

Is this possible? Does anyone have any suggestions as to what the best way of doing this might be?

Many Thanks

Jay

Any ideas anyone??