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.