I have many colums like
A B C D ...
1 20 50 10 ...
2 20 20 10 ...
3 60 10 80 ...
4 40 30 30 ...
5 40 50 40 ...
I would like to get
20 20 60 40 40 50 20 10 30 50 10 10 80 30 40
in a string.
Pseudocode
=CONCATENATE(B2:B6,C2:C6; D2:D6; ...)
How can you get a such a long string from many columns?