Help moving multiple non adjacent excel rows up one row

JTH3000 

You do NOT really want the name above the address. You should not want the name above the address. That would be a poor table or poor database. It would look like you expect addresses to look, so I understand why you might think you want it that way. But this is not an output sheet (if it were, it would already be laid out that way).

You want (or should want) the name to the left of the street address. And then, to the right, will be city. To the right of that, the zip. And so forth.  (Where are those additional data items, by the way?)

From that (with appropriate headings) you'd be able to print address labels via mail merge with Word, print address lists, whatever....

All of that preaching done, here in the attached is a formula that will get the name to the left of the street address (or, if you insist, on top)  But the truth is, you're still going to have clean up to do. That original layout was just wrong, so it might just make sense to devote the time to fix it. This formula will get you started.

FWIW, I've been there, done that, with other address files that have also not been created in solid Excel table fashion. It's a pain. Once you've moved the name, you can highlight a row (or rows) and delete them; then use Ctrl-Y to repeat the deletion with other highlighted rows. That makes the manual task move more quickly.

But you really should create an address database in the form of an Excel Table...single row per person, single cell per single data item. Then use Excel's abilities in sifting, sorting, mail-merging with Word...the whole world of flexible applications opens up.