Hi All
I have this attached example file, the 1st page is the raw data and the 2nd page is the ideal formatting I'm trying to acheive
What I need is for:
The cells in column A to be merged if the name is the same
The thick black outline to be applied to encircle every different unique name
How do I do this? Do I need to use a macro or is there a way to set the conditional formatting?
Bookmarks