Last seen: Jun 30, 2026
Hi Susanne, The most efficient way to get data from one workbook and place it in another is with Power Query, not VBA. 1. Power Query tab, or Da...
Hi Ed, I'd look for Stephen Few books: Information Dashboard Design: The Effective Visual Communication of Data Show Me the Numbers: Designi...
Hi Michael, I suspect the data type for those fields isn't set to Date in Power Query? Mynda
Hi Harry, You have to change the Load To settings. From the Excel worksheet open the queries pane > right-click the query > Load To. Deselect...
If you use Power BI then you can share your report using the Power BI (online) Service and your users would need a Power BI account, but that's free, ...
Hi Carolyn, I'm confused, isn't your first query 'Table1_2' what you need? Your second query has 34 rows in it, but the first only has 23. You o...
Ok, that's what I thought but with the missing student column is wasn't clear. All you need to do is unpivot the data and then use a PivotTable to ...
Hmmm, I wonder if there was a rogue space or other character in one or some of the cells that was fixed when you recreated the table. Anyhow, glad ...
Hi Tim, I'd set up several PivotTables at the various levels you want people to be able to drill down to. Insert Slicers that are connected to all ...
I'm sure you can improve on the steps. 🙂
Hi Carolyn, Please provide a sample Excel file with your data and query so we can see everything in context. Please also provide an example of the ...
Hi Jose, Yes, see attached. You'll notice I've used lots of technqiues so you may want to review some of the Power Query course lessons. Mynd...
Not really without seeing the file. I wonder if there is anything in the M code that specifically refers to these columns? Mynda
Hi Cheryl, You want to summarise each row? I'm asking because the rows themselves don't have any identifier. Should there be student names in your ...
Hi Charan, Connecting to Oracle is much the same as connecting to any of the other databases. You'll find it under the From Database menu > From...