How to Sort and Ignore Blanks in Google Sheets

Sorting data and ignoring blanks in Google Sheets is a helpful way to organize and analyze your data. Here's a step-by-step guide on how to do this:

Remove or Ignore Blanks While Sorting

1. Click on an empty cell in your sheet where you want to display the sorted data without blanks.
2. Enter the formula =SORT(FILTER(A1:A, A1:A <> ""),1,TRUE) and press Enter.
   • Replace A1:A with the range of cells you want to sort.
   • Replace 1 with the column number by which you want to sort the data.
   • Replace TRUE with FALSE if you want to sort the data in descending order.
3. The sorted data without blanks will be displayed in the cell where you entered the formula.

Example:

Let's say you have a list of names in cells A1 to A10, and you want to sort these names in ascending order while ignoring the blank cells.

1. Click on an empty cell, for example, B1.
2. Enter the formula =SORT(FILTER(A1:A10, A1:A10 <> ""),1,TRUE) and press Enter.
3. The sorted names without blanks will be displayed in column B.

Remember that sorting data using the SORT and FILTER functions will not change the original data in your sheet. If you want to modify the original data, you can copy the sorted data and paste it as values (Edit > Paste Special > Paste Values Only) over the original data range.