[Solved] Merge rows with same id

Discuss the spreadsheet application

[Solved] Merge rows with same id

Postby local native » Thu Jun 15, 2017 7:43 pm

Hello,

i have a spreadsheet that looks like this:

id | descr | value
1 | aaa: | 1
1 | bbb: | 2
1 | ccc: | 3
2 | ddd: | 4
2 | eee: | 5
2 | fff: | 6
id | descr | value
1 | aaa: | 1
1 | bbb: | 2
1 | ccc: | 3
2 | ddd: | 4
2 | eee: | 5
2 | fff: | 6

and i want to merge the rows so it looks like:

id | descr | value
1 | aaa: 1 </br> bbb: 2 </br> ccc: 3 | -
2 | ddd: 4 </br> eee: 5 </br> fff: 6 | -


(actually i don't care what is in the value column)

Do you believe that is possible to achieve?

Thanks!
Last edited by Hagar Delest on Sat Jun 17, 2017 4:19 pm, edited 1 time in total.
Reason: tagged [Solved].
Open Office 4.1.1 on Windows 8.1
local native
 
Posts: 4
Joined: Thu Jun 15, 2017 7:27 pm

Re: Merge rows with same id

Postby RusselB » Thu Jun 15, 2017 10:24 pm

Recommend looking at using a Pivot Table
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6170
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Merge rows with same id

Postby local native » Fri Jun 16, 2017 9:38 am

Thanks for the answer RusselB.

I'm afraid i can't merge the data into one cell with Pivot Tables.
Open Office 4.1.1 on Windows 8.1
local native
 
Posts: 4
Joined: Thu Jun 15, 2017 7:27 pm

Re: Merge rows with same id

Postby RusselB » Fri Jun 16, 2017 9:42 am

Generally speaking having multiple pieces of data in a single cell is a bad idea.
Can you explain why you want/need to have the data rearranged in the manner you have described?
Sometimes an explanation of why you want to do this helps us determine if there are other matters which may be affected.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6170
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Merge rows with same id

Postby local native » Fri Jun 16, 2017 9:51 am

I need to import the data into Woocommerce. Specifically all the specs should be import into a text area box.
Open Office 4.1.1 on Windows 8.1
local native
 
Posts: 4
Joined: Thu Jun 15, 2017 7:27 pm

Re: Merge rows with same id

Postby MrProgrammer » Fri Jun 16, 2017 5:01 pm

Hi, and welcome to the forum.

local native wrote:i have a spreadsheet that looks like this:
id     descr     value
1 aaa: 1
1 bbb: 2
1 ccc: 3
2 ddd: 4
2 eee: 5
2 fff: 6

and i want to merge the rows so it looks like:
id     descr 
1 aaa: 1 </br> bbb: 2 </br> ccc: 3
2 ddd: 4 </br> eee: 5 </br> fff: 6

Do you believe that is possible to achieve?
Add new columns shown in yellow. Click the autofilter in E1 and choose 1 (TRUE). Copy the filtered cells in columns F and G somewhere else.

201706160940.ods
(10.45 KiB) Downloaded 221 times

[Tutorial] How do I specify the formula for a column?
[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3944
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Merge rows with same id

Postby local native » Sat Jun 17, 2017 8:47 am

Wow!!! That worked perfect!!
I have no words to thank you for your time and effort in doing this!!
Thanks a million!
Open Office 4.1.1 on Windows 8.1
local native
 
Posts: 4
Joined: Thu Jun 15, 2017 7:27 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 11 guests