Ask Your Question

How can I sort a column's data by another column ?

asked 2016-11-05 15:08:03 +0200

Reserin gravatar image

Hello, I'm sure this question has a really simple answer but I just can't seem to find it. Here is the issue I am facing:

I have a spreadsheet where columns C D E are data from a database. I want to compare a corpus of data (columns A and B) to this database.

The words in A and C are similar but there are more rows in C and I only need the ones that match up with A.

How can I sort C to match the words in A ?

Thank you in advance

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-11-05 19:50:53 +0200

Reserin gravatar image

So basically I have something like this. I want to find a way to align CDE's rows with A, knowing that the names in A and C will be similar but there are more entries in C.

edit flag offensive delete link more


Create a custom series of Column A, and then use Sort on Column C by selecting custom sort.
Select the range of data in A and go to Tools->Options->Libreoffice Calc->Sort Lists and add your list to it. In column C select the range and Sort->Custom Sort and select your list in the dropdown.

adam1969in gravatar imageadam1969in ( 2016-11-06 03:13:43 +0200 )edit

Thanks ! it works only for the first few rows and then it's not aligned I don't get it. Maybe because sometimes in A there are more than one row with the same word ? Is there a way to get around that ?

Reserin gravatar imageReserin ( 2016-11-06 09:43:13 +0200 )edit

Would there be any way to have a blank row when A and C don't match up ?

Reserin gravatar imageReserin ( 2016-11-06 09:52:31 +0200 )edit

answered 2016-11-05 18:04:14 +0200

adam1969in gravatar image

Please provide sample data

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-11-05 15:08:03 +0200

Seen: 796 times

Last updated: Nov 05 '16