A planning grid has four direction labels and two gaps. You want one list for a checklist, in the same order someone reads across the grid.

Tell TOCOL to ignore blanks and scan by row

Put East, an empty cell and North in B2:D2. Put West, South and an empty cell in B3:D3. Enter the formula in F2, leaving space below:

=TOCOL(B2:D3,1,FALSE)

The 1 skips empty cells. FALSE scans across each row before moving down.

The first row contains East, blank, North. The second has West, South, blank.

Illustrated source grid. Leave the two empty cells genuinely empty.

Check where West appears

The result should read East, North, West, South. If West follows East immediately, check whether you requested a column-first scan. If a blank-looking value still appears, inspect the source for spaces or formulas that return empty text.

Reading by rows gives East, North, West and South in that order.

Illustrated result. A column-first scan would move West into second place.

Keep the original grid if the row and column labels carry context that the flattened list needs. Microsoft’s TOCOL scan-order reference.