TEXTSPLIT; incrementing row numbers; Numbers 14.4; autofill

Maybe by script.

But why would you want to do this?

In general you are better off with data in true tabular format, not interspersed with blank columns or rows.

If you haven't do so already be sure to have a look at the templates at File > New for good examples of effective document and table layout in Numbers.

SG

The row numbers you can do with a formula like

=IF(A<>"",ROW()-1,"")

This will spill down to the entire column

The empty columns you can do by hitting Tab twice instead of once after making an entry. Three times if it needs to create a new column.

What's key here (and missing) is what is in Worthy Images::F2?

Is that an entire string in a single cell, like:

or is it the starting point of a range of cells where the values are broken out, like:

There are probably combinations of TEXTSPLIT(), TRANSPOSE(), TAKE() and other functions that will help, but knowing what we're starting with (and how flexible that input is) will help a lot.