Hi, I mainly use google sheets so I'm a bit over my head with how to covert this code, especially without the same query function.
Basically the aim is to take data from tab 1 and show it in tab 2 so that it can be sorted in numerical order (priority) based on numbers in row M and also leaving out any blank rows.
The working code looks like this in sheets:
=QUERY(PPP!A:S,*,2)
*select M,B,C,F,O,P where M is NOT null order by M asc
Appreciate the help.
Basically the aim is to take data from tab 1 and show it in tab 2 so that it can be sorted in numerical order (priority) based on numbers in row M and also leaving out any blank rows.
The working code looks like this in sheets:
=QUERY(PPP!A:S,*,2)
*select M,B,C,F,O,P where M is NOT null order by M asc
Appreciate the help.