3

This question merges multiple sheets of the same dimension into a single sheet using an embedded array. I need the same solution, but with a dynamic collection of sheets stored in column G.

I've tried using JOIN and CONCATENATE to first create the array as a string and then evaluate it. But there's no equivalent EVAL function in Google Sheets so I can't process this text as a formula.

=CONCATENATE("={", JOIN(";", ARRAYFORMULA("filter('" & G:G & "'!A2:F, len('" & G:G & "'!A2:A))"), "}")

I've tried using ARRAYFORMULA and INDIRECT but INDIRECT doesn't work across array ranges so this only returns the first sheet in G1:

=ARRAYFORMULA(INDIRECT("'" & G:G & "'!A2:F"))
ziganotschka
  • 23,638
  • 2
  • 14
  • 29
E.Beach
  • 1,809
  • 1
  • 22
  • 34
  • Does the answer to this question get you on the right track? https://stackoverflow.com/questions/34227186/query-several-ranges-and-add-automatically-a-column-to-know-the-source-of-each-r/34311717#34311717 – kirkg13 Apr 23 '20 at 00:54
  • There's a related question which mentions that, there currently is no formula that's similar to the `EVAL` function: https://stackoverflow.com/questions/16303680/is-there-a-way-to-evaluate-a-formula-that-is-stored-in-a-cell – Gangula Oct 21 '21 at 18:46

0 Answers0