I’m trying to combine the values of a range of cells in separate rows, but
can’t get it to work. I can combine 2 rows, but nothing more than that. For
example: I have a spreadsheet with 5 rows made up of one cell each, a1-a5. It
looks like this:

Value1
Value2
Value3
Value4
Value5

I want to put the values of all 5 rows in 1 cell, so it looks like this:

Value1Value2Value3Value4Value5

I’ve tried using =CONCATENATE(A1:A5) but it only results in “Value1”. Since
my actual spreadsheet has over 42,000 rows it would not be possible from a
sanity standpoint (and Excel won’t allow it anyway) to put
=CONCATENATE(A1,A2,A3,A4,A5) etc.

Any ideas?

--
BPB