Maybe you should show us your spreadsheet.
Did you put everything in line 1, and nothing below it?
(I hope not!)
Please read
especially the filtering sample.
Be aware that AI2 lists are linked lists, not the contiguous arrays you might find in lower level languages like C, that allow you to romp through memory unfettered.
Proceeding off the end of one row in an AI2 table does not land you at the beginning of the next row.