The second 'easier' code worked best as for me it was easy to change the row cell references to (2) and carry out a delete duplicates on the second column also.

Is there a way that when removing duplicates is done a row top border line above each text entry in column 1 and two empty rows can be inserted before each column 1 text entry. eg (assuming dotted line as row border, star as new empty rows and hyphen as empty (post duplicates removal).

Bathroom
-
-
-
*
*
--------------------
Bedroom
-
-
*
*
-------------------
Loft

Thank you so much for your help