'Regarding IMPORTHTML Function
I am Using IMPORTHTML Function:
=IMPORTHTML("https://thefreedictionary.com/"&A1, "table")
However, the results come in a lot of cells. I have a list of things to do that, so I would need it to come in one single cell. Is there a way to retrieve the whole table in one single cell?
Solution 1:[1]
You can try the following.
=QUERY(TRANSPOSE(ARRAYFORMULA(CONCAT(QUERY(TRANSPOSE(IMPORTHTML("https://thefreedictionary.com/"&A1&"&in=","table",0)),,9^9),CHAR(10)))),,9^9)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Lorena Gomez |