Adding onto an array in Excel/Google Sheets

Question

Let's say I have a 2x2 array in Excel/Google Sheets:

={1,2;3,4}

To add on additional rows to this array -- for example, to make it 4x2, I can use ;:

However, how could additional columns be added on, for example, to make the array 2x4, something like:

Answer 1

In Google Sheets you can use the following 2 formulas

=SEQUENCE(4,2)

={SEQUENCE(2,2),SEQUENCE(2,2,5)}

Functions used:

• SEQUENCE

Answer 2

Arrays allow nesting in Google Sheets so you can try something like:

={B5:C6, {5,6;7,8}}