Question: 2 . Extracting Information - Dealing with blank ghost columns Often when importing data from Excel sheets, we have to deal with additional 'ghost' columns
Extracting Information Dealing with blank ghost columns
Often when importing data from Excel sheets, we have to deal with additional 'ghost' columns that appear to be completely blank.
How would you deal with ghost columns in an Excel file, in particular, if you did not know how many of these additional blank columns were going to be present each time the query is refreshed?
a Removing the column count from the file reference eg"Columns
b Use the "Remove Other Columns" instead of "Remove Columns"
c Use the column header to filter out blank values
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
