Sort data after blanks

please help i want to sort the name column such that each name starts after every blank cell.

I want it to look something like this. There’s a lot of rows. pls help thanks

would appreciate a solution in vba as well if possible


Hope the following sample helps you. (3.3 KB)