Ask Your Question

How to eliminate Duplicate columns [closed]

asked 2014-01-24 14:18:54 +0100

Ram.BM gravatar image

updated 2014-01-25 12:47:27 +0100

bencomp gravatar image

I have file has 3 columns like

column1         column2 column3 
Merchant City   13       AN
Merchant City   13       AN
Merchant City   13       AN

I want output like

column1         column2  column3 
Merchant City   13        AN

how to do this Please let us know..

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 2016-02-19 03:43:00.471514


These are duplicate rows, not duplicate columns.

Sajjad gravatar imageSajjad ( 2014-01-24 17:12:49 +0100 )edit

Yes you are right

Ram.BM gravatar imageRam.BM ( 2014-01-25 07:02:19 +0100 )edit

Please update your question :)

bencomp gravatar imagebencomp ( 2014-01-25 12:47:09 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-01-24 17:02:10 +0100

w_whalley gravatar image

You can do this with a filter. Select all the cells. On the main menu choose Data/Filter/Standard Filter. Make the condition column1 = .* (that's a period followed by an asterisk, i.e. everything) Choose More Options and check the boxes Regular expression and No duplication, then click OK The filtered list will be highlighted. You can copy and paste to a different part of the page or to a different sheet.

edit flag offensive delete link more



Thanx it works perfectly :)

Ram.BM gravatar imageRam.BM ( 2014-01-25 07:36:40 +0100 )edit

Is there any best tutorial for learn Libreoffice please let us know

Ram.BM gravatar imageRam.BM ( 2014-01-25 07:37:37 +0100 )edit

Question Tools

1 follower


Asked: 2014-01-24 14:18:54 +0100

Seen: 144 times

Last updated: Jan 24 '14