Forum Discussion

Copper Contributor

Jul 06, 2024

Seeking Tables help

Looking for help on tables. I have a long list (140+) of names. I'm trying to set up to have 2 columns of limited rows, (so it shows at 2 tables on a printed page) but want to have it so that if I ad...

Charting

excel

Formulas and Functions

Drew-N

Copper Contributor

Jul 06, 2024

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.

HansVogelaar

MVP

Jul 06, 2024

Drew-N

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