Append seems to be dropping data

[okiejw]

Hello,

I have successfully queried 33 tables, from multiple workbooks, together and all the individual tables created seem to have 100% of the source data (numbers) intact. However, when I append these tables, some of the data is pulled in while others are not (cells are blank). I have tried isolating some data that works and some not working to see if there are differences in source formulas or formatting but I find no issues. Any advice is greatly appreciated. I have searched in previous posts but can't seem to find if this issue has come up. BTW, I have a little over 2.5 days of combined experience with power query and online forums so please pardon any rookie mistakes. Thanks!!

 

[RoryA]

Is the data that is missing all of the same data type within a column, and of a different type to the data that is coming through correctly?

 

[okiejw]

thanks for the reply.
the data is all within a column, and the data coming through as well as what is missing are numbers formatted as numbers