Forum Discussion
Seeking Tables help
HansVogelaar That mostly worked, thanks! But one more if you can... The tables in mind are two parts. So one has a name, the other has a number. Could it be worked to have those two columns stay side by side?
Column1 Column2 (split) Column1Column2
Such as:
Smith | 1 Phillip | 5
Rosero | 2 Omar | 2
Ramirez | 6
is there a code to keep 6 with Ramirez as it shifts around on the displayed table? It would be edited on Data Sheet.
A lot clunkier. Let's say you want 30 rows per column, and you start in A2.
Enter the following formula in A2:
=LET(data, 'Data Sheet'!$A$2:$B$500, numrows, 30, firstcell, $A$2, v, INDEX(data, ROW()-ROW(firstcell)+1+numrows/2*(COLUMN()-COLUMN(firstcell)-ISODD(COLUMN()-COLUMN(firstcell))), ISODD(COLUMN()-COLUMN(firstcell))+1), w, IFERROR(v, ""), IF(w="", "", w))
Fill down to 30 rows, then fill to the right