#StackBounty: #libreoffice #sorting #libreoffice-calc Sort data in LibreOffice Calc according to numbers in other column

Bounty: 50

I have three columns:

  • Column A contains a count from 1 to 100, representing different sample stations
  • Column B contains numbers from column a (values between 1 to 100) but not all of them because I get a list with data from only some of the stations each time
  • Column C contains data associated with column B, for example a temperature reading at the sampling station or any other information

Now I would like to avoid to copy all information manually from Column C to where it belongs in Column A. I want to arrange column B in such a way that the number reflects the one in column A with empty spaces in column B when necessary. Afterwards column B can be eliminated.

As an example:

ColumnA, ColumnB, ColumnC
1,1,a
2,2,d
3,4,r
4,6,e
5,7,x
6,9,r
7,10,e
8,11,f
9,13,e
10,15,e 
...,...,...

Should afterwards look like this …

ColumnA, ColumnB, ColumnC
1,1,a
2,2,d
3,
4,4,r
5,
6,6,e
7,7,x
8,
9,9,r
10,10,e
11,11,f
12,
13,13,e
14,
15,15,e 
...,...,...

I’m pretty sure I did this a couple of years ago but now have forgotten. Any answer is much appreciated!


Get this bounty!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.