Power Query - csv file column values is mixed with values from other column

[Anonymous]

Hi,

I am having a trouble when I import a csv file to Power Query.

Originally and on my csv source file, I only have these data on my Column A (on green box). 
But when I imported my csv file in Power Query,  a lot of data from Column B is mixed up on Column A (around 850 records actually).

Need help. I am having a lot of errors when I load it to my PBI and having wrong output figures. 
Thanks a bunch in advance. 

[Anonymous]

Are you using """ (") as your delimiter? You may be better off splitting them on whitespace or tabs or something.

--Nate 

[Anonymous · Accepted solution]

Thanks @Anonymous for your advice.
 
Yes I am using "" as my delimeter, and when I changed to whitespace or tab or something, it gives the same error. 

However,  I tried to changed the Line Breaks from "Apply all line breaks" to "Ignore quoted line breaks" and surprisingly, it works 🙂 No mixed data from other columns already. And I am still using "" as my delimeter.