In ARRAY_LITERAL, an Array Literal was missing values for one or more rows - indirect formula error in google spreadsheet

Question

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.

score 13 · Accepted Answer · answered Apr 05 '18 at 17:42

13

Number of columns in both sheets must be the same:

Try

={Sheet1!A2:D10;Sheet2!A2:D10}

answered Apr 05 '18 at 17:42

TheMaster

45,448
6
62
85

I've deleted blank (and useless) columns, so it works fine, also with dynamicRange – alesdario Apr 05 '18 at 19:40

score 5 · Answer 2 · edited Jun 23 '21 at 04:09

5

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.

edited Jun 23 '21 at 04:09

marc_s

732,580
175
1,330
1,459

answered Jun 19 '21 at 11:37

UTF Forms

51
1
2

score 0 · Answer 3 · answered Jan 10 '23 at 05:56

0

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.

answered Jan 10 '23 at 05:56

nelsonmau

21
4

In ARRAY_LITERAL, an Array Literal was missing values for one or more rows - indirect formula error in google spreadsheet

3 Answers3

Linked

Related