Remove BLANK CELLS in chart data table in Excel
How to remove blank cells from a set of data so that a plotted line is continuous. Example shows blank cells being replaced by ‘N/A’ values using an IF statement.
Blanks
REMOVE BLANK cells in a list using Excel’s ADVANCED FILTER
Remove blank cells in a list of values in Excel using Advanced Filter, retaining the original list.