How to eliminate Duplicate columns

English
#1

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…

#2

These are duplicate rows, not duplicate columns.

#3

Yes you are right

#4

Please update your question :slight_smile:

#5

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.

#6

Thanx it works perfectly :slight_smile:

#7

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

#8

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.