Hello friends, hope all is well!
I placed multi CSV workbooks in a folder, and PowerQuery to compile them in one sheet.
All went well. What is driving me nuts, is that I found null cells, even though I filled all the empty cells with zero in the original CSV files.
i.e. when going to the CSV files and I filter I wont find (blanks).
Why is this happening, and how to fix it, I am afraid to delete the nulls in PQ editor and end up erasing important data.
Please help and thank you so much in advance
Bookmarks