[Solved] Combining data in columns

Discuss the spreadsheet application

[Solved] Combining data in columns

Postby banjobiotic » Tue Jan 14, 2020 9:55 pm

Hello and please forgive my ignorance. I am trying combine the data in columns B through G in my calc file. Reading the forums here I have gotten as far as this formula =B2&" "&C2&" "&D2&" "&E2&" "&F2&" "&G2. What I can't get past is how to use that formula to get all the rows combined. If I paste that formula into the H3 for example I just get the data from row 2. How do I get the formula copied into all rows and auto adjust for the different row numbers? Please be as detailed as possible with your answers and assume I really don't know what I'm doing. Thanks!
Last edited by MrProgrammer on Thu Jan 16, 2020 4:42 am, edited 1 time in total.
Reason: Tagged ✓ [Solved]
OpenOffice version 4.1.7
Windows 10
banjobiotic
 
Posts: 2
Joined: Tue Jan 14, 2020 9:47 pm

Re: Combining data in columns

Postby FJCC » Tue Jan 14, 2020 10:10 pm

There are several ways to do this. One of them starts by clicking on the cell that contains the formula. It will then be surrounded by a black border and in the lower right corner there will be a small black square. Click and hold on that square and drag it down as far as you want the formula to be copied. As the formula is copied down the row reference will be automatically increased.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7752
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Combining data in columns

Postby robleyd » Tue Jan 14, 2020 11:43 pm

Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3467
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Combining data in columns

Postby banjobiotic » Thu Jan 16, 2020 2:49 am

FJCC wrote:There are several ways to do this. One of them starts by clicking on the cell that contains the formula. It will then be surrounded by a black border and in the lower right corner there will be a small black square. Click and hold on that square and drag it down as far as you want the formula to be copied. As the formula is copied down the row reference will be automatically increased.



That was what I needed! Thank you!
OpenOffice version 4.1.7
Windows 10
banjobiotic
 
Posts: 2
Joined: Tue Jan 14, 2020 9:47 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 24 guests