Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Power Query - import from folder text files. Loading in one column.

0

Hi,

Sorry for my question but I couldn't found an answer for it.

So problem is - I'm importing data in power query from folder with 3 .txt files. Each of this file should contain 3 columns. (they are separated by TAB).

Then I am removing all other columns except binary. After that expanding this binary column and getting all data into one column. Where it should be in three columns. This is how others is getting data but for me it doesn't work. 

I am using office 2013.

When I am importing as .txt file not folder then it works, but in this case I need from folder to import.

Hope someone will help me to understand what could be wrong. Maybe some settings must change?

Than you in advance!

Answer
Discuss



Answer the Question

You must create an account to use the forum. Create an Account or Login