topic Re: Line Break Cell Power Query in Power Query

Line Break Cell Power Query

snaseem — Sun, 11 Sep 2022 12:08:14 GMT

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.

Re: Line Break Cell Power Query

Anonymous — Mon, 12 Sep 2022 07:23:48 GMT

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.

Re: Line Break Cell Power Query

snaseem — Tue, 13 Sep 2022 06:45:23 GMT

I will upload the file for your review.