Thanks for responding.
The column contains varios sets of duplicate entries in the rows. eg.

Table column before code is run

Bathroom
Bathroom
Bathroom
Bedroom
Bedroom
Bedroom
Loft
Loft
Loft
Loft ' etc

If you visualize the above lines of text to be representing table rows column cells the result I need (and am currently getting) would be (asuming the hyphens as empty cells. (which I need)

Result After code is run

Bathroom
-
-
-
Bedroom
-
Loft
-
-
-

I will be grateful if you could explain the logic to check there is a next. I think this is the crux of the issue for me in so far as the code goes to error when there is no next row. (An example would be really helpful)

Thank you