1 | City | #N/A | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
2 | Irvine, CA | ||||||||||
3 | New York, NY | ||||||||||
4 | Raleigh, NC | ||||||||||
5 | Mountain View, CA | ||||||||||
6 | |||||||||||
7 | |||||||||||
8 | |||||||||||
9 | |||||||||||
10 | You just need to populate the other highlighted cells. Column A is manually populated with cities of interest; cell B1 uses the formula below: | ||||||||||
11 | =IMPORTXML("https://city-data-search.cbdm.app/api/multi/get-headers&" & JOIN("&", ARRAYFORMULA(LOWER(SUBSTITUTE(SUBSTITUTE(FILTER(A2:A, LEN(A2:A)), ", ", ","), " ", "+")))), "/multi/data") |