I originally posted this in excel 2007 help but this might be a better place to ask it.

I have 2 different lists in excel.

The first one has all the business info, name, address, phone number, etc...
The next has the business phone number and rank in Google.

I combine both lists into 1 sheet and then add a function =IF(Phone Number is Equal to Phone Number above then Yes, if not No)

Is there a way to combine both rows when the answer to the IF function is Yes?

I have attached an excel file I have been trying to figure this out with.Excel Mege Test.xlsx