you can, use this example to implement to your case
=query({IMPORTHTML("https://www.bloomberg.com/markets/currencies","table")},"select Col1,Col2",1)
Or hit me a msg if you need any further help
Artem Hryhorian
- 1
- 1