--finds next next blank (or non-blank) cell in column
--select starting cell, and run
property searchFor : missing value
tell application "Numbers"
set t to front document's active sheet's first table whose selection range's class is range
tell t's selection range
set currentRow to its first cell's row's address
set searchCol to its first cell's column's address
end tell
tell t's column searchCol
repeat with i from currentRow + 1 to count cells
if cell i's value is searchFor then --add not if want to find non-blank
set t's selection range to cell i
return
end if
end repeat
end tell
end tell
So, this is easy to solve in Excel... I don't have access to Numbers at the moment, but I'll give you the solution I'm aware of and you can confirm whether it works in Numbers like it does Excel.
You can create a column with the following formula:
=Row() - 1
This will always give you one less than the "default" row number, which is what you are looking for. It also won't be affected by sorting.
A complete reference of functions that are available in Numbers can be found HERE, including the ROW function.
Best Answer
This is currently not possible within cells.
As a workaround, you can change the angle of the text labels for the X axis on a chart and use this as the header for your table.
Alternatively, you can create text boxes and rotate these.
You can provide feedback to Apple regarding this on the following page: