Sort non-contiguous columns together?

Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

Is it possible to sort non-contiguous columns, while leaving intervening columns unsorted?

example:
I have data in columns A, B, and C. I want to sort columns A and C, with A being the primary sort key, and leave data in column B unsorted.

If this is not possible, what’s the best method for accomplishing this?

Copy column B, sort columns A:C, paste column B.

1 Like