Ask Your Question
0

To put numbers in columns into a string

asked 2015-01-05 10:10:21 +0100

Masi gravatar image

updated 2015-01-05 11:09:10 +0100

karolus gravatar image

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?

edit retag flag offensive close merge delete

Comments

As it seems that you have many and long columns it might be the best to consider a macro. You can download have a look at the free guides here: https://wiki.documentfoundation.org/D...

ROSt52 gravatar imageROSt52 ( 2015-01-05 11:11:06 +0100 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2015-01-05 11:06:05 +0100

karolus gravatar image

Hallo

Take the Extension out of this Thread

Install it.

and enter Formula: =PYJOIN(TRANSPOSE(B2:E6);" ")

edit flag offensive delete link more

Comments

@karolus - Knowing more is of advantage!!! Great!

ROSt52 gravatar imageROSt52 ( 2015-01-05 12:06:55 +0100 )edit

Great extension! However, I would like to find a native way to do thing. Do you have any idea? It is just simple Mathematics.

Masi gravatar imageMasi ( 2016-06-13 17:32:53 +0100 )edit

No, its String-concatanation - no maths!

If you would like to find a native way ?? … so search for it!

karolus gravatar imagekarolus ( 2016-06-14 00:02:00 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-01-05 10:10:21 +0100

Seen: 41 times

Last updated: Jan 05 '15