Sorting and showing specific colums

Question

I have data that I want to sort in my google sheets; but I want to show only specific columns and not others.

Here's an example :

After a =SORT() in an other sheet; I'd like to have something like this :

And with an other =SORT() have this :

I tried with FILTER() But I can't manage to get rid of the Type column

Of course I don't want to modify the first table

But I could use sorted tables containing only the name and not wathever value was used to sort them

EDIT :

Can try `=FILTER(SORT(A2:D,3,0),{1,0,1,0})`. – Harun24hr Sep 28 '22 at 10:25 — Harun24hr, Sep 28 '22 at 10:25

Osm · Answer 1 · 2022-09-28T13:15:00.887

2

One

=QUERY({A:D};"Select Col1,Col4 where Col1 <> '' Order by Col4 desc";1)

Two

=QUERY({A:D};"Select Col1,Col3 where Col1 <> '' Order by Col3 desc";1)

edited Sep 28 '22 at 13:15

answered Sep 28 '22 at 09:56

Osm

1

Query is giant function in gs. – Harun24hr Sep 28 '22 at 10:14
Why not `=QUERY(A:D,"Select A,D Order by D DESC",1)`? – Harun24hr Sep 28 '22 at 10:16
So he could paste another formula in the refrence directly, and he lern `{}` arrys from it also. – Osm Sep 28 '22 at 10:19
Then combine two query into one array so that op no need to write two function separately. – Harun24hr Sep 28 '22 at 10:24
To quote the OP *`After a =SORT() in an other sheet;`* and *`And with an other =SORT() have this :...`* he did't specify, suggest it in your answer maybe he wants it that way. – Osm Sep 28 '22 at 10:27
Works pretty well, but in my original table, I have some cell with no value, is it possible to exclude any valu that is null ? ( Made an edit to the question) – Neo Sep 28 '22 at 12:39
@Neo the answer is updated – Osm Sep 28 '22 at 12:42
It doesn' work; I have an error telling me no result found – Neo Sep 28 '22 at 12:49
Can you share what you adjusted? or a screenshot – Osm Sep 28 '22 at 12:51
Edited the answer again – Neo Sep 28 '22 at 12:54
Its a Local issue `;` in your locsl instead of comma `,` in US local – Osm Sep 28 '22 at 12:57
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/248409/discussion-between-neo-and-osm). – Neo Sep 28 '22 at 13:08
@Neo Test it now its working in your sheet – Osm Sep 28 '22 at 13:13

marikamitsos · Accepted Answer · 2022-09-28T13:09:17.340

2

You can create a virtual array {A2:A,D2:D} and use

=SORT({A2:A,D2:D},2,0)

or even

=SORT({A2:A,C2:C},2,0)

(Do adjust the formula according to your ranges and locale)

In your case it would be:

=SORT({A2:A\D2:D};2;0)

edited Sep 28 '22 at 13:09

answered Sep 28 '22 at 10:07

marikamitsos

Tried it, It put me column A then B in the same column but not sorted – Neo Sep 28 '22 at 12:36
*"It put me column A then B in the same column"*. You probably need `;` – marikamitsos Sep 28 '22 at 12:45
Nope, exact same result – Neo Sep 28 '22 at 12:50
https://docs.google.com/spreadsheets/d/1e6FDK9_kbZU6RvGFxHTVRHLsC3mMdaUgu77JfgxvqII/edit?usp=sharing – Neo Sep 28 '22 at 13:00
Your sheet is private. Please make it public. – marikamitsos Sep 28 '22 at 13:01
It's now public – Neo Sep 28 '22 at 13:02
Answer updated. – marikamitsos Sep 28 '22 at 13:09
Still the same problem – Neo Sep 28 '22 at 13:11
1

I cannot find an issue in our end. Try `=QUERY(SORT({A2:A\C2:C};2;0);"where Col2 is not null")` – marikamitsos Sep 28 '22 at 13:13
@marikamitsos you are [Anonymous Moose](https://i.imgur.com/c2J35ae.png) :) ? – Osm Sep 28 '22 at 13:18

score 1 · Answer 3 · answered Sep 28 '22 at 19:40

use:

=SORT(FILTER({A2:A\C2:C}; C2:C<>""); 2; )

and:

=SORT(FILTER({A2:A\D2:D}; D2:D<>""); 2; )

pros: SORT with FILTER is faster and more reliable than QUERY that can eat your data

also, see how to convert commas to semicolons: https://stackoverflow.com/a/73767720/5632629

3 Answers3