Hello All,

Is there a macro that can be ran that would go through a spreadsheet and do the following:

Identify identical values in column F. If values are identical, look at column A and merge company names into a single cell in column A. Once merge is completed. Go back to column F and delete duplicate.

Thank you guys for the help!

Macro.jpg