Creating a task/macro in Numbers

First run made it far too complicated.

With the data in two compact lists, each column gets a far simpler formula:

The formula shown is entered in A1 of the second table.

The second formula is entered in B1 of the second table,

Both are then filled down as many rows as needed.

A1: INDEX(Table 1::$A,ROW(cell))

The formula in B1 is essentially the same, requiring only the addition of +4 to the ROW() value as this group of data starts 4 rows below the first group.

B1: INDEX(Table 1::$A,ROW(cell)+4)

Apologies for going astray in my first reply.

Regards,

Barry

Put the data in a table:

the name the table with the data "Source" (just to match my example)

then create a second table that is the dimensions of the array (4 rows by 2 columns)... like the table on the right (name "Table 1-1")

select cell A1 in that new table and type the equal sign, then type (or copy and paste the formula) from here:

OFFSET(Source::$A$1,(ROW()−1)+(COLUMN(cell)−1)×ROWS(A:B),0)

short hand for this is:

A1=OFFSET(Source::$A$1,(ROW()−1)+(COLUMN(cell)−1)×ROWS(A:B),0)

select cell A1, copy

select all the cells of the table, paste

if the array on the left table changes, then adjust the number expected rows and columns to match

HI Kathy,

OOPS—I see I tucked an extra field in there, making each record one row longer than needed. Should require only changing the 4 in the formula to a 3, and removing column C from the second table. Posting the note here, as the Edit window may time out before I finish revising the table.

B.

second note— Not quite. Different arrangement of data than noted.

Regards,

Barry