Note. I should tell you that I have also used your delete duplicates code to work on the second column (Part) on completion of the delete duplicates of the first column (Area) In the table at the moment the header row is as follows.
Area | Part | Desription | Condition|

Currently The (unique) (one instance) ) (once delete duplicates code is run) Area names are set out under the heading row. As are the Parts, Description and Condition information.

Each Area is unique but there are many 'Parts' for an Area. Each 'Part' has a Description and a Condition comment.

I have also applied your delete duplicates code to another version of a report that has two further RH columns. However, it is still only the first two colums that are affected by the delete duplicates and this other version also works well. Thanks, Tony