Styjun

How do I professionally let my manager know I'll quit over an issue?

I don't like coffee, neither beer. How to politely work my way around that in a business situation?

Is there any proof that high saturation and contrast makes a picture more appealing in social media?

Ruining the family name

LWC - Local Dev - How can I run the local server on HTTPS?

RandomInteger with equal number of 1 and -1

If the Dragon's Breath spell is cast on a familiar, does it use the wizard's DC or familiar's DC?

Hit the Bulls Eye with T in the Center

When did Nuremberg adopt the Gregorian Calendar?

What is the meaning of "понаехать"?

What does it mean to not be able to take the derivative of a function multiple times?

How many people are necessary to maintain modern civilisation?

Are all Ringwraiths called Nazgûl in LotR?

Boss wants someone else to lead a project based on the idea I presented to him

Should I include an appendix for inessential, yet related worldbuilding to my story?

Encounter design and XP thresholds

Is "Busen" just the area between the breasts?

Why tighten down in a criss-cross pattern?

How do I farm creepers for XP without them exploding?

How would modern naval warfare have to have developed differently for battleships to still be relevant in the 21st century?

Confusion over 220 and 230 volt outlets

Designing a magic-compatible polearm

Is there any difference between Т34ВМ1 and КМ1858ВМ1/3?

Why do all the teams that I have worked with always finish a sprint without completion of all the stories?

importrange query with order by and nulls

Having problems with dates and times in Google SpreadsheetsQuery and import targeted data in seperate Google SpreadsheetsData Reduction via ImportRangeVLOOKUP in IMPORTRANGEIMPORTRANGE with CONDITIONSHow to order by a column with Visualization Query APIMaking a query formula search box with partial matchCan't run filter on query results in google sheetsImportRange works differently for only one link - huge delay in update

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I'm using Importrange to bring data from another google sheet and then querying it to remove blank rows and want to order my data by certain standards. I've run into a problem with null values as they go to the top when ordering but I want them to go to the bottom (yet using ascending order).

I've already tried every possible solution from the internets I could find like using isnull, isblank and others but nothing seems to do the trick.

=query(importrange("google sheet", "Sheet!A2:L20"), "select * where Col1 is not null order by Col4, Col7, Col6")

This is the query I am currently using which obviously is not working as the null values have "lower" value than any other number in the system.

Any help from you guys?

google-sheets

share|improve this question

edited Mar 25 at 8:08

Santeri

asked Mar 25 at 7:45

SanteriSanteri

12

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Unfortunately not and apparently this forum does not support any convenient way to paste tables here.
  
  – Santeri
  Mar 25 at 8:09
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  no need to paste tables. just paste a link and enable view in sharing (green button)
  
  – player0
  Mar 25 at 10:29
  

  
  
  
  

add a comment | 

0

I'm using Importrange to bring data from another google sheet and then querying it to remove blank rows and want to order my data by certain standards. I've run into a problem with null values as they go to the top when ordering but I want them to go to the bottom (yet using ascending order).

I've already tried every possible solution from the internets I could find like using isnull, isblank and others but nothing seems to do the trick.

=query(importrange("google sheet", "Sheet!A2:L20"), "select * where Col1 is not null order by Col4, Col7, Col6")

This is the query I am currently using which obviously is not working as the null values have "lower" value than any other number in the system.

Any help from you guys?

google-sheets

share|improve this question

edited Mar 25 at 8:08

Santeri

asked Mar 25 at 7:45

SanteriSanteri

12

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Unfortunately not and apparently this forum does not support any convenient way to paste tables here.
  
  – Santeri
  Mar 25 at 8:09
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  no need to paste tables. just paste a link and enable view in sharing (green button)
  
  – player0
  Mar 25 at 10:29
  

  
  
  
  

add a comment | 

I'm using Importrange to bring data from another google sheet and then querying it to remove blank rows and want to order my data by certain standards. I've run into a problem with null values as they go to the top when ordering but I want them to go to the bottom (yet using ascending order).

I've already tried every possible solution from the internets I could find like using isnull, isblank and others but nothing seems to do the trick.

=query(importrange("google sheet", "Sheet!A2:L20"), "select * where Col1 is not null order by Col4, Col7, Col6")

This is the query I am currently using which obviously is not working as the null values have "lower" value than any other number in the system.

Any help from you guys?

google-sheets

share|improve this question

edited Mar 25 at 8:08

Santeri

asked Mar 25 at 7:45

SanteriSanteri

12

=query(importrange("google sheet", "Sheet!A2:L20"), "select * where Col1 is not null order by Col4, Col7, Col6")

share|improve this question

edited Mar 25 at 8:08

Santeri

asked Mar 25 at 7:45

SanteriSanteri

12

share|improve this question

edited Mar 25 at 8:08

Santeri

asked Mar 25 at 7:45

SanteriSanteri

12

asked Mar 25 at 7:45

SanteriSanteri

12

asked Mar 25 at 7:45

SanteriSanteri

12