Forum Discussion
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...
I fixed the problem by setting the Query Source option about "Line Breaks" to "ignore quoted line breaks"
jbwtp
Memorable Member
Memorable MemberHi Judsonteacher,
Do you mind having a read of this: https://blog.crossjoin.co.uk/2018/03/09/an-in-depth-look-at-the-csv-document-m-function/ ? I think the issue that you have may relate to how the CSV.Document imports your data and Chris in his blog has a realy deep dive into how this function can be configured with various settings.
Hope this will help.
Kind regards,
John