extract columns from website

Hi all,

I am trying to extract data/columns from a website.

Here is the import and link =importxml("http://www.owgr.com/ranking?pageNo=1&pageSize=150&country=All", "//td/a[1]")

I have managed to extract the column with names, but i would like extract the following columns:

- This Week
- Country
- Name

Any help will be much appreciated.

Thanks,

This formula will get the columns "This week" and "Name"

Please Login or Register  to view this content.

that is great. thank you so much. I may get you to help me with a few more in the future if that is ok? I will private message you when i need the help.

Thanks