PQ rows with excessive height // how to stop?

[michellepace]

Hello,

Is there any way to opt for Power Query not to expand the height of rows where there are newline characters?

Best wishes,
Michelle

[Icey]

Hi @michellepace ,

Please let us know if the replies above are helpful.
 
If they are, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
 
If not, please give us more details.
 
 
Best Regards,
Icey

[Fowmy]

@michellepace 

Before expanding the column, try applying the Replace Value option to replace CR and LF using the Insert Special Character.

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

WebsiteYouTube  LinkedIn

[AlB · Accepted solution]

Hi @michellepace 

Try turning off the Show whitespace option under View

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers