Help moving multiple non adjacent excel rows up one row

I have been given a spreadsheet with names and addresses. Problem is the names are below the addresses. Luckily all the names have an (H) beside them so I do have that. Is there a way through formula...