Hi,
Is there anything equivalent to the TOCOL function in Excel for Calc?
What I’m trying to do is:
I have values in A1, A2, A3 and so on, going down the A column.I also have values in B1, B2, and so on going down the B column.
Say for example A1 = 3, A2 = Hi, B1 = 56, B2 = Penguin
I would like to have a formula in C1 that makes column C to look like this:
C1 = 3, C2 = Hi, C3 = 56, C4 = Penguin
There are periodically values added at the bottom of columns A & B, so the formula in C1 has to include the totality of columns A and B and ignore the blanks at the bottom.
In Excel I could use the TOCOL function with the following formula:
=tocol(A:B,1,TRUE)
In the above formula 1 is to ignore blanks and True is to read by column instead of by row.
Thanks!
(since Lo 25.8)