Importing files with variable number of columns

[Monsignor]

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?

 

[sandy666]

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)