Delete rows, then reorganise remaining data

Hi there

I'm hoping someone can help me delete some rows from a worksheet, then reorganise a lot more.

I've got an exceptionally slow way of doing it at the moment with millions of lines of very bad code from just recording various steps but it crashes my computer every time so I'm hoping there's a quicker way.

I've attached a sample document for what the information looks like now and what I'd like it to look like afterwards.

I've used two sheets for clarity but ideally would like the action to happen over the top on the one sheet. This is not essential though.

There are three members in the sample but in reality there could be 100s - it will vary each time. The data in A will always follow the same pattern, but in B there may be the odd field that is missing information.

I'm hoping to have the information in A18:B20 deleted, to follow in this way for each member, so deleting the rows relating to the below, then reorganising the remaining info as per the After sheet.

Type
Last Viewed
Last notified

Thanks as ever for your help.

Steve