Forum Discussion
Resolver IIIPQ rows with excessive height // how to stop?
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
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
3 Replies
- AlB
Community Champion
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
- Fowmy
Super User
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 🙂
- Icey
Community Support
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
