Importing files with variable number of columns

Monsignor

Board Regular
Joined
May 30, 2011
Messages
158
I noticed something odd today and I don't know if this is new or if I just never encountered this before.


  • I have 3 files in a folder and imported from the folder into Power Query.
  • 2 of the files have 2 columns, 1 file has 3 columns.
  • Power Query imported just the first 2 columns from each file.

I'm used to Power Query sometimes importing too many columns (several empty columns) rather than too few. Is there a way to tell Power Query to import all columns?
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
4,686
maybe:
Edit not Combine
expand Content
expand Data (choose columns you want to load)
select all columns and remove duplicates
then remove top/bottom rows with null (if necessary)
 

Forum statistics

Threads
1,089,689
Messages
5,409,805
Members
403,279
Latest member
ricardovobarros

This Week's Hot Topics

Top