I'm trying to write a simple formula that concatenates each entry in a given column of a spreadsheet, interspersed with newline characters. In other words,
=CONCATENATE(B2, CHAR(10), B3, CHAR(10), B4, CHAR(10), ... , CHAR(10), B130)
Is there any way of achieve this without having to type the whole thing out by hand? Even copying and pasting so I just have to modify the cell references is pretty laborious. I was thinking that there might be some way of implementing a for loop?