title: sort empty cells to top
body: <p>I am working on a google sheet to organize my school's locker assignment system.  For unassigned lockers, the student/grade/major/etc. cells are blank.  ideally i need a function that will sort the lockers to push all unassigned (blank student cells) to the top of the sheet.  However, regardless of if i sort ascending or descending, google api seems to ignore any blank cells and pushes them to the bottom.  Once this sheet is finished it will have close to 1000 lockers so it will be super annoying to have to scroll all the way down every time a teacher wanted to assign an open locker. any thoughts?  </p>