I'm new to power query and I'm importing table information in from an appended query from another spreadsheet. I have 26 columns that are visual in my appended sheet that I am importing from. However when I connect the table and import the data, I automatically receive many more columns that I don't want. How can I make these columns go away and stay away when I add new columns in my source data?
You may automate that if there is a formal logic which columns to keep. That could be names of the columns, or name of the last column, or number of columns, or keep all non-blank columns, or something else. Concrete implementation depends on such logic, but it's better to discuss having sample file in place.