11

Hy Guys, i'm triyng to merge two different Tab of the same Google SpreadSheet.

I'm using this formula in the first cell

={indirect(dynamicRange1);indirect(dynamicRange2)}

where dynamicRange 1 and 2 are:

  • FirstSheet!2:2606
  • SecondSheet!2:6598

But shomething does not work fine.

"In ARRAY_LITERAL, an Array Literal was missing values for one or more rows"

If i use just one dynamicRance everything works fine, both something goes wrong.

Improve this question

3 Answers 3

Reset to default
20

Number of columns in both sheets must be the same:

Try 

={Sheet1!A2:D10;Sheet2!A2:D10}
Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

I've deleted blank (and useless) columns, so it works fine, also with dynamicRange
8

This error is generated when the number of columns in two array is not the same:

In ARRAY_LITERAL, an array literal was missing values for one or more rows

You need same number of columns in all arrays.

Improve this answer

Comments

1

You need same number of columns in all arrays. You should keep the same number of columns in all imported sheets, even if you have empty columns. Deleting empty column in at least one sheet will cause an error.

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.