Select your range that needs to be sorted, then go to data-sort, sort by column B, sort on values (if your selection has headers, check that box) then click ok. The rows with no values will be placed at the end of the table.
If this is not what you need, then you better be more specific, maybe uploading a sample of your data it's a good idea.