Forum

Hi Chris, I'm not aware of a way to connect PQ to read from your PST file. If your email was connected to Exchange that would be a different matte...

No worries. If there were prizes for badly formatted data exports then we'd have a contender. Phil

Hi Christine, Your image shows the workbook embedded in a web page so I'll need the address of that web page and the embed code you are using from ...

Hi Yousef, I've used the code I wrote in this post and modified it slightly to do what you want. I also used the RangetoHTML function from Ro...

Hi Kaushik, As Purfleet said this has been covered many times, did you use the Search function at the top of the site? Searching for 'email' in th...

Hi Miguel, If you know the file is from Spain then import it using the Spanish (Spain) locale es-ES? Likewise for the other countries. Phil

Hi Scott, the workbook doesn't quite match up with the pictures or your description,so it's a little tricky to follow and I don't want to write cod...

Hi Florence, That data dump is in a really bad format for working with! I'm sure it's not you fault but it would make lives so much easier if data...

no worries 🙂

Hi Jacek, Try the attached query. It works in the sense that it gives you the desired table, but relies on filling down missing values for: Top...

Hi Scott, Please supply a workbook with data, we can't write any code to affect that data without it. Regards Phil

Hi Mikaela, There's no code in the workbook you supplied? I've taken the code from this post and put it in your workbook, in the Sheet1 cod...

Hi Guanyu, Yes the custom list will be stored in the workbook so if it's opened elsewhere you (or someone else) can sort using that CL. However,...

No worries 🙂