How to use import range to import content into one single cell instead of entire row?

user_8176451 0
Viewed 208

I am using: = ImportRange("<key>","B2:B")

How I get it is:

enter image description here

But how I want it to be is:

enter image description here

into a single cell. Can anyone guide me to achieve this?

google-sheets-formula google-sheets
1 Answers

How about using JOIN and/or TEXTJOIN?

Modified formula:

=JOIN(",",ImportRange("<key>","B2:B"))

or

=TEXTJOIN(",",TRUE,ImportRange("<key>","B2:B"))
  • By above modification, the retrieved values are put in one cell with the delimiter of ,.

References:

user_71086530
Related