This is fab, you have made my day. thank you so much.


I’ve just tried it, it works when a person has two instruments, however when a person has one instrument, it deletes most of the blank rows but leaves one row underneath. I’m not sure which row I need to amend. Please can you show me which line needs amending. Thank you.

So sorry I had a zero in one of the rows in the data scources from a formula I was using to transpose the data. It’s working. Thank you so much.