Delete Empty rows between data:

1. Select all columns containing data.
2. Click the Sort icon (either Ascending or Descending).

Alternatively, we can use auto filter and delete the rows if we don’t want to sort.