Ask Your Question
0

How to sort columns in rows

asked 2017-08-20 05:33:03 +0200

seschenburg gravatar image

updated 2017-08-20 05:49:54 +0200

I've a block of columns and rows that are similar to this:

  • 1 |8 |38|47|43
  • 21|32|3 |37|26
  • 23|12|33|65|51

and I want them to sort into this:

  • 1 |8 |38|43|47
  • 3 |21|26|32|37
  • 12|23|33|51|65

IOW, I want the columns in each row to reorder such that the number values increase to the right. I select a block of cells...Sort...enable the Left to Right (Sort Columns) feature...OK, but it only works on one row at a time, even if I have multiple rows selected in the block. What am I doing wrong?

LibreOffice 5.3 with latest updates TIA

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-08-20 08:24:57 +0200

Lupp gravatar image

If you sort a 2D range the first sortkey will apply.
Additional columns/rows will join the first one. That's the behaviour mostly needed.
You cannot change that. (Neither if a column is used as first key (option top down) nor if it is a row (option left to right.)

edit flag offensive delete link more

Comments

With a bit of work, selecting and sorting row by row.

m.a.riosv gravatar imagem.a.riosv ( 2017-08-20 12:01:22 +0200 )edit

I see. Hmmm, 2000+ rows. bleh.

Ok, thanks.

seschenburg gravatar imageseschenburg ( 2017-08-20 14:19:56 +0200 )edit

it can be automated with a macro.

librebel gravatar imagelibrebel ( 2017-08-20 14:42:41 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-08-20 05:33:03 +0200

Seen: 1,406 times

Last updated: Aug 20 '17