I have a Google Sheet with multiple columns and some of the columns have empty cells at arbitrary locations. I want to 'condense' the columns, that is, simply shift upwards all cells in the column so that the column only consists of cells with values inside. All of my Google searches provide results for removing entire blank rows/columns, but do not relate to dealing with empty cells on the row/column level.
A demo Sheet can be found here.