I
I
Illarion Labahua2018-02-21 10:03:01
Google Sheets
Illarion Labahua, 2018-02-21 10:03:01

How to merge identical arrays or columns in tables?

When you need to add two rows, you do this: {Array1;Array2;Array3}
But if I need to add two columns, then I feel like a pervert:
=TRANSPOSE({TRANSPOSE(Array1);TRANSPOSE(Array2);TRANSPOSE(Array3 )})
In addition to complicating the perception of code that is larger than necessary, I assume that such an array is calculated a little longer.
How to make it easier?
Table

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
Illarion Labahua, 2018-02-21
@Illarion_me

It just so happened that after writing in a toaster, I immediately understand how to do everything myself.
Thanks to the toaster for this)))
PS
={B7:B17\D7:D17\F7:F17}

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question