Sort data after blanks

[gregoryoffodum (gregory2727)]

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

[Yoichi]

Hi,

Hope the following sample helps you.

Sample20210911-2.zip (3.3 KB)

Regards,