1

I'm having some trouble to import data values from many spreadsheets to a single one. I need to import all the values from all columns "A" of each spreadsheets to the column "A" of a new one. How can I do that?

Thanks for your help!

1 Answer 1

0

Try something like this:

=lambda( 
  spreadsheetIds, rangeA1, header, 
  query( 
    reduce( 
      header, spreadsheetIds, 
      lambda( 
        result, id, 
        { 
          result; 
          iferror(importrange(id, rangeA1), header) 
        } 
      ) 
    ), 
    "where Col1 is not null", 1 
  ) 
)( 
  { "...put spreadsheet id here...", "...and here...", "...and here..." }, 
  "Data!A2:A", 
  "Imported" 
)
4
  • it don't work :S thanks for your comments :S Feb 10 at 22:53
  • Edited the answer. Make sure you have authorized the imports. Feb 10 at 23:05
  • Yes I do but it shows "Imported" on cells :S sorry I'm not even sure if I did it right :S Feb 11 at 1:19
  • Consider sharing a publicly editable sample spreadsheet where the issue can be reproduced. There is a blank sheet maker that lets you share safely. Feb 11 at 8:07

Your Answer

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

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