CODEWITHSUNDEEP
libreofficesubtotallibreoffice-calc
curiousity
curiousity

Reputation: 4741

Group or sort values in calc (libre office)

Sorry for non-programmatic question - I need a help with libre office tools. I have (for example) such table, where the first column is an IP addresses

A       B      C  
2.3.4.5      bbb     22c
1.2.1.4      aaa     11v
4.2.3.5      ccc     33v
1.2.1.4      ddd     55c

And I need to group (or sort) them - to compare a data from the same IP, so the result must be something like this:

A       B      C  
1.2.1.4      aaa     11v
1.2.1.4      ddd     55c
2.3.4.5      bbb     22c
4.2.3.5      ccc     33v

how could it be done ?

Upvotes: 1

Views: 2391

Answers (1)

Campa
Campa

Reputation: 4505

Data -> Sort

Then specify the keys (in your case, simply Column A, Ascending)

enter image description here

@see https://help.libreoffice.org/Calc/Sorting_Data

Upvotes: 1

Related Questions