I am trying to merge rows in my sheet based on column value matches. Specifically, I have two columns I would like to check for matches - Last Name (Column B) and Email Address (Column C). If matches are found in both these columns, then the two rows must be merged. Please look at the screenshots below to see what I am trying to achieve.
Note that there are many more columns in the worksheet, with the user able to add in new columns at the end as required. I would like to be able to merge across all these columns as long as the column values in B and C are the same.
Some of the other code I have come across either limits the number of columns to be merged across or checks against one column only (e.g. only Column B and not column C). I am quite new to VBA and hence would appreciate any pointers here.