How can I merge multiple rows at a time ?

General discussion on OpenOffice Calc and its spreadsheets.

How can I merge multiple rows at a time ?

Postby Micheal T. Leo » Sat Oct 11, 2014 4:59 am

Hi everyone,

Is there a way to merge multiple rows at a time while keeping the row values separate ?

For example, I want to merge the following:
Row 1: Jennifer | Johnson
Row 2: Dan | Paulson

into

Row 1: Jennifer Johnson
Row 2: Dan Paulson

The only way I can see to do this right now is to highlight each individual row and merge it separately.

Is there a better way to do this ? Can I do this with multiple rows at once? Or a better way?

Thanks,
Micheal T. Leo
 
Posts: 26
Joined: Mon Mar 24, 2014 6:26 am

Re: How can I merge multiple rows at a time ?

Postby Ricky G. Marion » Mon Oct 13, 2014 11:53 am

Hi,

To merge multiple rows at a time, First pair of names in A1 and B1,
C1 =A1&" "&B1
copy down C1

thanks,
Ricky G. Marion
 
Posts: 25
Joined: Mon Mar 24, 2014 6:33 am

Re: How can I merge multiple rows at a time ?

Postby UniSET » Mon Oct 13, 2014 12:11 pm

Hello Everyone,

Just expand the formula, and move the formula over so that it always ends up in an empty cell.
If you're not sure how many you're going to need, you could put the formula into column A and your data into columns B->?
Using this, for 3 it'd be =B1&" "&C1&" "&D1
For 4: =B1&" "&C1&" "&D1&" "&E1
For 5: =B1&" "&C1&" "&D1&" "&E1&" "&F1
etc.

thanks,
UniSET
 
Posts: 22
Joined: Tue Mar 25, 2014 6:33 am


Return to OpenOffice.org Calc

Who is online

Users browsing this forum: No registered users and 2 guests

cron