Hi all,
I'm trying to do a WEB query in Excel, but I am having a little problem. I'm trying to add data from a website. That website is very simple, it has only 2 columns which one is DATA (days) and the other one PERCENTAGE (%). I'm using data -> insert data from web menu.
The problem is that when I do this, Excel only lets me choose to query both columns, and I only want PERCENTAGE column. Is there any way I can select only the column that I want?
Thanks
I'm trying to do a WEB query in Excel, but I am having a little problem. I'm trying to add data from a website. That website is very simple, it has only 2 columns which one is DATA (days) and the other one PERCENTAGE (%). I'm using data -> insert data from web menu.
The problem is that when I do this, Excel only lets me choose to query both columns, and I only want PERCENTAGE column. Is there any way I can select only the column that I want?
Thanks