If {range1; range2; range3} (I believe this is called embedded arrays) outputs the combined data in a column - top to down, what puts them side by side next to each other?

The 3 ranges may or may not differ in dimensions (different number of columns, which embedded arrays dislike) and I'm trying not to use 3 different formulas in different cells.


1 Answer 1

  • side by side / next to each other: {range1, range2, range3}
  • all in one column stacked under: {range1; range2; range3}

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.