Forum Discussion
excel table adding extra data after end of "real" data
Hello, I need to combine multiple data sets with different column headings in order to create a pivot table. I have found power querry and it works with a few of the tables. I have created tables t...
Possibly some hidden characters in some of the cells. I usually have to fight with CHAR(0160). Its a little front end work to validate the data and see if any cells are populated with non-visible characters like that. Check for string lengths greater than the visible characters or try a search and replace. TRIM and CLEAN do not get rid of all the offending characters but is a good start. TRIM and CLEAN are available in PQ as well as the replace. You can also have a calculation in PQ that kicks back an error for the rows and then remove the errors.