
Last seen: May 30, 2025
Hi, As the URL does not change as you go through the pages of data, that data is loaded using JavaScript and unfortunately can't be scraped using P...
Hi Andrew, Nothing attached. Can you please supply a file rather than a picture? Saves us having to recreate your data. regards Phil
Nothing attached. Click Start Upload after selecting the file
Hi WW, No file attached. After you select the file click on Start Upload. Phil
Hi Antony, No file attached. Click Start Upload after selecting the file(s). Phil
Hi Brian, Can you please supply your file/data. Regards Phil
No worries. Phil
Hi Martin, Yes Power Query can do this. Create a new Custom Column and for each row call your API. So if you have a column called Postcode, in y...
Hi James, If you put 0:1:00 in a cell and 0:1:30 in another cell then divide the former by the latter, you get 0.667. What have you tried that h...
Hi James, Can you give an example and the expected result please? You can't divide 'times' as such. What is 12.30am divided by 3.45pm? Makes n...
Hi Brenda, Nothing is attached. After you select the file you need to click Start upload to load it to the site. Phil
Hi Ivan, Nothing is attached. After you select the file click Start Upload to upload it. Phil
Hi Dixon, The video you linked to is about Power Pivot so I'm not following how that relates to your query about Power View. Sorry I don't have 48...
Hi, Please be specific (give an example) about what type of 'button' you mean and in what context. Regards Phil
Hi Celeste, No Power Query can't do that. VBA can, is VBA a viable solution for you? Regards Phil