Row Skip Issue

[ExcelMA]

Hi everyone,

I'm having some trouble with Power Query and CSV (Comma Delimited) files. When I import a CSV that appears formatted correctly, some rows are getting split strangely. Half the data jumps to the next row. This happens with multiple files, so I'm hoping someone can help me figure out a solution.

I've attached a screenshot that shows how the data looks after the import issue occurs.

Any advice would be greatly appreciated!

 

[Alex Blakenburg]

You might want to give this a try:
edit your query as follows :
Csv.Document(file, [Delimiter=",", Encoding=1252, QuoteStyle=QuoteStyle.Csv])

Your current query probably shows the default of QuoteStyle=QuoteStyle.None
Source: [URL="https://community.fabric.microsoft.com/t5/Desktop/CSV-Carriage-Returns-Splitting-Data-to-New-Rows-in-Power-Query/td-p/1941737"]CSV Carriage Returns Splitting Data to New Rows in Power Query[/URL]
And references: Csv.Document - PowerQuery M