Ask Your Question

Calc: "Attach" cell to another cell, so that when "sort" is used on cell it's attached to, it remains in the same position relative to it? [closed]

asked 2020-07-14 18:09:09 +0200

appreciatethehelp gravatar image

updated 2020-07-15 09:42:29 +0200

Libreoffice 6, OS Mojave

I've got a 2-column list, with text in the left-hand column and numbers in the right. I want to do an alphabeticized "sort" on the left-hand column, however I want the numbers in each right-hand cell to remain adjacent to the cells they were adjacent to before the "sort" was performed; is there a way to "attach" the right-hand column cells to their left-hand counterparts?

For example:

B | 1

C | 2

A | 3

Becomes (after alphabeticised Sort of left-hand column):

A | 3

B | 1

C | 2

NOT (as it would be without "attaching" right-hand column cells to left-hand column cells):

A | 1

B | 2

C | 3

As always, thanks for helping!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2020-07-15 09:48:40.848141


Doesn't selecting the two columns when sorting work??

Mike Kaganski gravatar imageMike Kaganski ( 2020-07-14 18:12:21 +0200 )edit

Writer: ....

Why do you put that on starting your title?

Opaque gravatar imageOpaque ( 2020-07-14 18:24:47 +0200 )edit

Sorry- brain fart; was meant to to be "Calc", have amended accordingly.

appreciatethehelp gravatar imageappreciatethehelp ( 2020-07-15 09:43:03 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-07-14 18:34:06 +0200

Opaque gravatar image


as @Mike Kaganski commented - select both columns and use Data -> Sort to select the order of sorting:

image description

Hope that helps.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2020-07-14 18:09:09 +0200

Seen: 47 times

Last updated: Jul 15 '20