Ask Your Question
0

How to remove duplicate rows in calc? [closed]

asked 2013-08-13 16:02:42 +0200

alexbrogan gravatar image

Basically downloaded a list of customers from paypal.

One of the columns is for products, but there for every product there is a duplicate row beneath that just says 'shopping cart'.

I would go through and delete each row seperately, but for 5000+ customers this seems incredibly lengthy and was hoping there was a way to do it all at once?

Cheers

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-06 23:35:09.829640

2 Answers

Sort by » oldest newest most voted
1

answered 2013-08-14 07:04:21 +0200

L-user gravatar image

You can also mark column/s and select Data | Sort and it will sort the column and obviously group all of the 'shopping cart' together, so you can easily delete them.

edit flag offensive delete link more
1

answered 2013-08-13 20:43:18 +0200

m.a.riosv gravatar image

If all rows to delete have "shopping cart" and only those have it.

Go to the top-left cell of data range or select the data range with their headers.

Menu/Data/Filter/Autofilter.

In the header with "shopping cart" field click the arrow and select only "shopping cart".

Click on the top(row numbers)-left(column numbers) box, this select all rows an columns.

Click on the number of header row for deselect.

Right-click on any other row number and select delete rows.

Go again to the filter and select All.

Of course you can filter by other fields or use the Standard filter (with optional regular expression).

edit flag offensive delete link more

Question Tools

2 followers

Stats

Asked: 2013-08-13 16:02:42 +0200

Seen: 57,377 times

Last updated: Aug 14 '13