Forum

Consolidate multipl...
 
Notifications
Clear all

Consolidate multiple sheets within workbook

2 Posts
2 Users
0 Reactions
73 Views
(@christinet)
Posts: 5
Active Member
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 workbookScreenshot-PQ-Expand.jpg

 

Screenshot-PQ.jpg

 
Posted : 22/04/2023 8:33 pm
(@mynda)
Posts: 4761
Member Admin
 

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
Share: