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?
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,129,932
Messages
5,639,067
Members
417,067
Latest member
rohitbabshet

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top