Delete multiple empty cells in multiple columns and moving data up, witout Macros

Hello! I've done a lot of research and unfortunatly cannot get exactly what I need.

1. I'm doing my best to avoid Macros
2. I want to delete multiple empty cells in a range of multiple columns, then move data up. Ultimatly creating a simple list of names.

I have posted a link of what I want excel to do.

Any help would be greatly appreciated! Please note that this has to be as user-friendly as possible.

Thank you!! I had the list filtered and it doesn't seem to work when you have it filtered.

Thank you again...

@ CoraF

Welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

The other issue I had with my worksheet was the formulas that rendering a 'blank' cell, wasn't a true blank cell. Because of this i made my 'false' na() producing a #NA. Because of this I was able to search for 'error' on the Go To Special search option. I also found this solution in the forum.

Thank you for all the help!