Notifications
Clear all
Topic starter
Hi,
following is my issue
I have 16 files, for which there are 21 sheets where I want to combine data
there are 13 columns, the first column is blank
power query suggests to expand 12 colums, which is OK because only 12 columns contain data
BUT for 1 file (with 4 sheets) I have an issue
it takes the blank column as first column, what can be the reason for this?
Kr Claudine
Posted : 20/04/2018 11:01 am
Just my 2 cents contribution, but...
Might there be characters like spaces in that column? Try selecting the entire column and choosing Home > Clear > Clear All
Alternatively, is there a print area or range name set up for those four sheets? Delete these if there are.
Posted : 20/04/2018 2:24 pm
