Excel Forum

Agregated sheet data from 13 xls files, auto selected "column 1" for 1 file is different

Claudine Beunens

Member

Members

Power Query

Forum Posts: 33

Member Since:
April 20, 2018

Offline

April 20, 2018 - 1:01 am

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

Rudi

Cape Town

New Member

Members

Forum Posts: 2

Member Since:
April 19, 2018

Offline

April 20, 2018 - 4:24 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.

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)

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