Jump to content
Maze

how to combine three columns in calc - how to do that with a calc-sheet that contains more than 360 lines of data

Recommended Posts

dear community,

how to combine three columns in calc  - how to do that with a calc-sheet that contains more than 360 lines of data?

Share this post


Link to post
Share on other sites

"Combine"? And why would the number of rows make a difference?

Share this post


Link to post
Share on other sites

hello dear experts

 combine three columns in calc  - how to do that with a calc-sheet that contains more than 360 lines of data

 

see the attachment for more details.

 

look forward to hear from you

_zellen_zusammenbau_.png

Share this post


Link to post
Share on other sites

Merged. One question, one thread.

I'll ask again: what do you mean by "combine", and why is the number of rows a problem?

Share this post


Link to post
Share on other sites

good day dear requinix

 

many thanks for the quick reply and for the help.

Note: the number of rows is no problem. But how should the combination of the cells be achieved:  i need to combine the cells row by row -

 

in other words:  only the rows in one line should be combined - That means:

the combination in row 1 should "collect" all the data of all the cells that are in row 1

the combination in row 2 should "collect" all the data of all the cells that are in row 2

the combination in row 3 should "collect" all the data of all the cells that are in row 3

and so forth....

 

well i try to achive that in Cac -

i come back and report all the findings

 

have a great day

 

 

 

Share this post


Link to post
Share on other sites

 

 

 

 

update: some infos bout solutins - unfortunatly in german.

https://praxistipps.chip.de/openoffice-calc-verketten-von-zellen-so-gehts_32956

 

 

Quote


 

Verketten von Zellen in OpenOffice Calc - Verbinden Sie z.B. Name<n

Öffnen Sie OpenOffice Calc und erstellen Sie Ihre Zelleninhalte. Z.B. können Sie in einer Zelle einen Vornamen eintragen, in einer anderen Zelle einen Nachnamen. Um den kompletten Namen in einer anderen Zelle anzuzeigen, sollten Sie die Zellen verketten. Das geht folgendermaßen:

 

Klicken Sie in die Zelle, in der der verkettete Inhalt angezeigt werden soll.

Im Formelfeld geben Sie nun "=VERKETTEN(Zelle1;" ";Zelle2)" an.

Statt "Zelle1" bzw. "Zelle2" geben Sie den jeweiligen Zellennamen an, z.B. A3 oder B8. Beachten Sie das Leerzeichen zwischen den Zellennamen.

 


 

try to achive that solution here with the data...

will come back and report

Share this post


Link to post
Share on other sites

This seems suspiciously complicated, but I think you might be able to do

=CONCATENATE(B1,IF(C1="","",";"&TRANSPOSE(INDIRECT(ADDRESS(ROW(),3)&":"&ADDRESS(ROW(),COUNTA(C1:Z1)+2)))))

(sounds like you'll have to translate the function names though)

Hinges on whether Calc allows you to concatenate a string ";" with each cell in a range.

Share this post


Link to post
Share on other sites

hello dear Requinix many many thanks for the reply

i tried to do it like so...:

how do you like it!? Can i do it like so!?

with  Format -> Cells - Merge : - see the image below:

and subeqeuentliy - what i have achieved with the first line - i can apply to all the 365 lines  - do you think that this is a way to do it!?

love to hear from you

regards

Screenshot_calc_merge_cells__1.png

Share this post


Link to post
Share on other sites

You won't get the semicolons but it sure looks like that does what you want.

Did you perhaps try it?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.