Forum

If you don't apply any filters at Step 4 in the Consolidate Sheets with Power Query tutorial, then any new tables will be automatically included. T...

Those PDFs contain images, rather than tables. Power Query can't see the data because it's an image. That's why you can't select the cells in the PDF ...

They're not formatted as an Excel Table. Follow the link in my post above for Excel Table and you'll see what I mean. If you also open the file I shar...

Hi Dwight, Thanks for sharing the file. The only problem I see with that data is it isn't formatted in an Excel Table or defined by a name, as requ...

Yes, that's easy to fix but there's a few steps. Best if you can upload that sample Excel file and we can put the solution in the file for you.

Hard to tell much from that screenshot. If you click on the Error cell it will show you an error message with further information. That said, it l...

Hi Antonia, Try just using the data type drop down on the column to apply the Date Time data type. This should apply it using the nomenclature for ...

Hi Dieneba, If you click on the cog icon in the Final Data Query Source step, you'll see I did this using the Append Queries tool (Home tab of the ...

Hi Mardi, It's difficult to help with a screenshot. Please copy an extract of the data to a sample Excel file that you can share with us. Also incl...

Hi Dwight, Welcome to our forum! You can and should use Power Query for this. See this tutorial: consolidate Excel sheets with Power Query. Mynd...

Hi Leela, Welcome to our forum. Your question is difficult to answer because the image you have shared is too small and those helping would have to...

Hi Em, Your question isn't clear, which is probably why it's been unanswered for a few days now. Please upload a sample Excel file that illustrates...

Hi Dieneba, Thanks for the file. You can do this with Power Query. First, use a merge to lookup the BU in the original document and bring it into t...

Hi Andrea, Unfortunately, you can't change the space between slicer buttons. All you can do is change the button size. Mynda

Hi Dieneba, It's not clear what you're referring to as there is nothing in your file called Data 1 and Data 1b that I could see. However, you can u...