I am trying to import a table from the lower part of following website to Google Sheets: http://www.etnet.com.hk/www/tc/warrants/search_cbbc_hsi.php
I used the formula:
=IMPORTXML("http://www.etnet.com.hk/www/tc/warrants/search_cbbc_hsi.php","//td//a")
but the output is messy and contains many other data outside the table.
Anyone help?