
Claudine Beunens
Member
Members
Power Query
Power Query

Forum Posts: 33
Member Since:
April 20, 2018
April 20, 2018

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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Lynnette Altomari, Roy Lutke, Jeff Krueger, Natasha Smith, Monique Roussouw
Guest(s) 12
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Sopi Yuniarti
sandra parker
LAFONSO HERNANDEZ
Hayden Hao
Angela chen
Sean Moore
John Chisholm
vexokeb sdfg
John Jack
Malcolm Toy
Forum Stats:
Groups: 3
Forums: 24
Topics: 6214
Posts: 27243
Member Stats:
Guest Posters: 49
Members: 31894
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
