December 6, 2021
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
July 16, 2010
This is a locale issue. Please see this tutorial for how to resolve it: Power Query Change Type Using Locale.