Forum

Hi Mike, Hasn't Mynda already answered you when you contacted her via Linked In and email? regards Phil

Hi Amir, You'll need to load it into Excel as a table, then save that file as a CSV - comma delimited - why use pipes as delimiters? Regards ...

Hi Amir, You might be able to do this with formulae, I hadn't thought about it as you asked for a solution with Power Query? Regards Phil

Hi Joe, You haven't included the URL of the web page you want to scrape. Can you explain clearly what it is you want to scrape. What is draught...

Hi Carolyn, Have you seen this article, it may help to work through it Get Data from OneDrive or Sharepoint with Power Query Regards Phil

Hi Lea, You can use Power Query to do this, see the attached file. These are the steps: 1. Create a table from your data (CTRL+T) 2. Set ...

Hi, Need a lot more info to help you. What error are you getting? Can you provide a screenshot? Why are you using Basic Auth? Does your int...

Hi, Please supply sample data in an Excel file. Hard to write any code without it. Regards Phil

Hi Amir, You haven't provided a sample of the data, or your query, so it's nearly impossible to tell you what is going wrong. If you look at the...

Hi Rosemary, With Power Query you can use the Text.TrimStart and Text.TrimEnd functions - see attached file Text.TrimStart - PowerQuery M |...

Hi Mihai, Transpose (Transform -> Transpose) the table then you have 1 column of lists and you can expand them all at once. Regards Phil

Hi Viktor, The errors are caused because you have rows in your Production Data where the Site Name is a #N/A error, for example Row 1831 to Row 186...

Hi PB, Dates are stored as 'serial numbers' in Excel. Please read this for explanation Excel Date and Time - Everything you need to know (myonl...

Hi Viktor, Attached is a file that fills in the blanks as requested. There are a few issues though as there are some Site ID's where their Use W...

Hi Bakshi, Unfortunately Power Query doesn't have a way to login to websites that require a form to be completed via the web browser interface. If...