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 d...
  • Judsonteacher's avatar
    4 years ago

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