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

Question

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

How I get it is:

But how I want it to be is:

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

Answer 1

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:

• JOIN
• TEXTJOIN