Forum

Here's the OP's file

@jenoye Sorry, your post was stuck in moderation but as you'd attached it to a non-related post I missed it. Please start new topics when posting...

Hi @cribbage Don't use merged cells - ever! Unmerge the cells and attach a copy of your file, much easier to help when we have the file. Regard...

Hi John, Yes you can do this. Columns in Power Query are lists so you can access items in that column/list using an index (starting at 0 for the fi...

Initial post updated with OP message and file

no worries 🙂

Hi Sherry, I'd try using the Command Prompt rather than VBA for this. See if del "C:UsersbarneshOneDrive - HIIDocumentsHIITrainingOnboarding* - ...

Hi KS, No worries. Yes using Table.Buffer and List.Buffer are the way I'd do it too, it makes PQ much faster. Regards Phil

Hi KS, To ignore case in the TextTable you can make the text and the words you're searching for all the same case by using either Text.Lower or Tex...

HI, No file attached. After selecting the file, click Start Upload. Phil

Hi, Your criteria are too vague. Please provide sample data and examples of the results you want. Regards Phil

Hi Liam, What is the purpose of this? How does this problem relate to your work? Regards Phil

Hi Dale, No file attached. Click Start Upload after selecting the file. Phil

Thanks Mark. Presumably after the bank started providing the data in XLSX format you had to create a new query to load that data - separate to your...

Hi Sridevi, If you wish to learn how to create Dashboards then you really need to take our Excel Dashboards Course. This topic isn't something t...