how to Sort sheet for importhtml via google sheet, was using Query not solved

user_16847784 0
Viewed 192

hi how to sort the google sheet with row running number was been added automatic by us as automatic by importhtml sync + then sort descending row number Z - A, A - Z OR 10 - 1 , 1 - 10 in a row?

but the table name [ No, VERSION, SOURCE, RELEASE DATE, IS BETA ] - are not be sort in first row.. only sort second row : eg (B2),(C2),(D2),(E2)...

here the code i was used :

=QUERY(
  IMPORTHTML(
   "https:// wabetainfo.com/updates/",
   "table",2),
  "select * offset 0",1)

i mean for this : can make;

if i use this direct code direct

IMPORTHTML("https:// wabetainfo.com/updates/", "table",2)

the data second column are the latest one update - mean September 2 ....

and now i want to make the latest one update that go make descending sort became last one column.

that mean :

last row, column = latest update

second row, column = previous / oldest update..

that all

thanks for helping

google-sheets-formula spreadsheet google-sheets-api google-sheets
1 Answers

Try

=query(
{IMPORTHTML("https://wabetainfo.com/updates/", "table",2),
arrayformula(substitute(query(IMPORTHTML("https://wabetainfo.com/updates/", "table",2),"select Col3"),",","")*1)},
"select Col1,Col2,Col3,Col4 where Col1 is not null order by Col5")
user_150193800
Related