I am using the google sheets query function to import data from one sheet into another. It is functioning properly and taking only the data I want. However, some of the columns from which data is being imported isn't appearing in the new sheet, where the query function is being called. The interesting thing is that when I edited the query function to import data from a smaller range of values, the values reappear. I attached pictures to demonstrate exactly what I am referring to.
Why is it so that only certain columns won't import if the size of the data range is too big and what can I do to make it work regardless of the data range size?