ImportXML not expanded as would overwrite data

user_19032169 0
Viewed 79

on this report I have an IMPORTXML function in Column B which is crawling a URL for the closing date specifically. URLS on column A

It mostly works fine, but on a couple of instance it will retrieve a #REF!, and the reason is stated as "Array result was not expanded because it would overwrite data in B58." This is happening in Cell B57 currently

anyone know how I can fix this?

Thank you

google-query-language google-sheets-formula flatten google-sheets arrays
1 Answers

use limit like:

=QUERY(FLATTEN(IMPORTXML(A59, "//*[@id]")), 
 "where lower(Col1) starts with 'closing date' limit 1", )
user_56326290
Related