Answer the question
In order to leave comments, you need to log in
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
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 questionAsk a Question
731 491 924 answers to any question