Forum Discussion
pcman24
Nov 07, 2020Copper Contributor
Power Query Append Error
Needing help! 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 impo...
- Nov 07, 2020
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.
SergeiBaklan
Nov 07, 2020Diamond Contributor
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.