Ask Your Question

CALC: Sort multiple columns

asked 2016-04-01 12:05:31 +0200

MartinG gravatar image

Is it possible to sort two columns in a way that each value that only exists in one column generates an empty row in the other column?

These are the 2 Columns:

image description

And the result should look like this:

image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-04-01 17:48:23 +0200

pierre-yves samyn gravatar image


An example in the TriDeuxColonnes.ods attached, that uses 3 columns of intermediate results.

I hope someone will find a simpler solution.


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-04-01 12:05:31 +0200

Seen: 536 times

Last updated: Apr 01 '16