I'm attempting to import some data to my Google Sheet.
QUERY to reshape my data, an example code of what I am trying to import is as follows:
=query(importhtml("http://statfox.com/cbb/cbbteam.asp?teamid=DUKE&season=2019&log=1", "table",8),"Select * where Col2 is not null order by Col1")
Unfortunately, in many cases where a team is an underdog and the line should be +#, the query is not returning the value.
If I remove the
QUERY and use the following
importhtml all values show up correctly:
Any insight into the matter or ideas on what might be causing this or solutions would be greatly appreciated.