Hello,

I tried the above, but it only puts TRUE on 1 of the blank rows. There is 3 blank rows and I want to leave only 1.

your method is resulting in:

A2 business name FALSE
A3 Address 1 FALSE
A4 Address 2 FALSE
A5 Address 3 FALSE
A6 Postcode FALSE
A7 Opening time FALSE
A8 blank FALSE
A9 blank FALSE
A10 blank TRUE
A11 Address 1 FALSE
A12 Adress 2 FALSE

etc etc.....