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.

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.

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.



