Formula Combining data from Rows that Match !

General discussion on OpenOffice Calc and its spreadsheets.

Formula Combining data from Rows that Match !

Postby LiverPAN » Sat Sep 27, 2014 4:24 am

Basically I have a calc sheet that has over 50k entries that have two columns one is sku and the other is url.

example :

SKU00001 http://domain.com/3452/image1.jpg
SKU00001 http://domain.com/7456/image2.jpg
SKU00001 http://domain.com/2345/image3.jpg
SKU00001 http://domain.com/4567/image4.jpg
SKU00002 http://domain.com/1234/image1.jpg
SKU00002 http://domain.com/7456/image2.jpg
SKU00003 http://domain.com/2745/image1.jpg
SKU00003 http://domain.com/2784/image2.jpg
SKU00003 http://domain.com/1734/image3.jpg
SKU00003 http://domain.com/8645/image4.jpg
SKU00003 http://domain.com/8532/image5.jpg
SKU00003 http://domain.com/4323/image6.jpg
SKU00003 http://domain.com/3452/image7.jpg

results:
Code: Select all
SKU00001    http://domain.com/3452/image1.jpg|http://domain.com/7456/image2.jpg|...........
SKU00002    http://domain.com/1234/image1.jpg|http://domain.com/7456/image2.jpg
SKU00003    http://domain.com/2745/image1.jpg|http://domain.com/2784/image2.jpg|...........

notice that bar between the image urls

Any help would be greatly appreciated.
LiverPAN
 
Posts: 24
Joined: Tue Mar 25, 2014 6:30 am

Re: Formula Combining data from Rows that Match !

Postby Tansenn » Sat Sep 27, 2014 9:48 am

Hi,

Welcome to the forum!
Suppose your example table starts in A2. Give the table some headers in row 1: SKU, Link, Complete, Result.
Put in C2: =A3<>A2
and in D2: =IF(A2=A1;D1&"|"&B2;B2)
Select both C2 and D2 and doubleclick the fill handle in the lower right corner of D2.
Click A1, then click Data>Filter>Autofilter, and use the arrow in C1 to select 1 or TRUE.

I hope this will help you.
thanks,
Tansenn
 
Posts: 28
Joined: Tue Mar 25, 2014 6:27 am


Return to OpenOffice.org Calc

Who is online

Users browsing this forum: No registered users and 2 guests

cron