Create macro to compare two rows and if two columns agree merge all

[Poseidons-Palace]

Hi Guys,

I have a spreadsheet (attached) that I am wanting to create a macro for that will assess all the rows but only check columns A and B to make sure they are the same and if so merge the two rows, delete one but keep both sets of values in column G, so it would read TS, HT or vice versa.

I hope this makes sense!!!

The problem is that although the majority of the values may be side by side as in rows 5-6 and 17-18 this is not always the case see rows 22-25.

So far the entire sheet has 1143 entries, done in alphabetical order using column A and I am only at the first entry for "E" so as you can guess this could be quite a large file in completion.

Apologies, I have no code as I really have no idea where to start but would appreciate, immensely, any help.

Thanks