Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
25
Views
Topic starter
Hi Mynda, I have watched the online webminar and tried to consolidate the data but it only extracted data for Table_Jan, even though I selected Jan - Aug Tables. It was able to see/expand the contents of tables but unable to consolidate it in a single worksheet - it is only showing data for Jan and others were showing as null. I have attached
screenshot and workbook
Posted : 22/04/2023 8:33 pm
Hi Christine,
This is a locale issue. Please see this tutorial for how to resolve it: Power Query Change Type Using Locale.
Mynda
Posted : 24/04/2023 7:11 pm