Line Break Cell Power Query

[snaseem]

Hi, 

I have an excel file that contain line break values in certain cell, not all cells. When this file is loaded into Power Query (Transform), it shifted the cell into 2 rows but in different columns. This way, all values in other columns are disturbed. 

As an example, some part of Blue Owl value (line break text) has been shifted to id column. Because it is a numeric data type, it threw some error due to text.

I tried some solutions from online, it didn't work.

[Anonymous]

Hi @snaseem ,

Based on my test, it works well.

In excel

When it is loaded into Power Query

If so, can you provide more detailed information?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[snaseem]

I will upload the file for your review.