How to sort a range based on criteria

[zazybang]

Hey guys, so i have a roster that has names in the first 3 rows. How do i sort the 3 in which the emtpy row will be automatically placed at the bottom of the 3. EX:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Names:[/TD]
[TD]Notes:[/TD]
[/TR]
[TR]
[TD]X[/TD]
[TD]Blah blah blah[/TD]
[/TR]
[TR]
[TD]Y[/TD]
[TD]asdgh[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]fgsde[/TD]
[/TR]
</tbody>[/TABLE]

If i delete all the data in Row 2 (Name: "X") how would i sort the section so that row 2 would appear below the other 2 rows.

 

[JoeMo]

Sort on Names, ascending. Check the box that says "My data has headers".

 

[zazybang]

How do i do that?

 

[JoeMo]

On the ribbon Data>Sort & Filter>Sort