Forum Discussion

Judsonteacher's avatar
Judsonteacher
Regular Visitor
4 years ago
Solved

Power Query .csv Cells Have Multiple Lines Delimits Imported Data Thereby Misaligning Columns

Hi,

 

I am using Power Query (from web, Sharepoint link) to import some data from a single .csv which has some cells with multiple lines.  I don't need to manipulate those cells, but the imported data is misaligned after importing.

 

For example: Here is the data from the .CSV (you can see it's in the notes column)

 

 

 

But after importing the data, what I guess is happening is the multiple lines is being delimited into subsequent columns which makes everything after this entry in the wrong column.  

 

You can see now the data from "Notes" is under "Staff: Center"

 

I have not done any transformations.  I have tried re-exporting the raw data multiple times, relinking the file, deleting and building it over again multiple times, all to no avail.

 

Any suggestions how to fix?

  • I fixed the problem by setting the Query Source option about "Line Breaks" to "ignore quoted line breaks"

2 Replies