How to remove Line breaks using Power Query in Excel

How to remove the Line breaks in a data set using Power Query in Excel is explained in this video.

Disclosure: Some of the links are Affiliate Links! If you buy something through one of those links, you won't pay a penny more, but we will get a small commission, which helps keep the lights on. Thank you for your support!

#PowerQuery #RemoveLineBreak

[TimEllisWW]

Thanks, Simple solution to cleaning up the data.

[violimlucas]

Thank you, thank you, thank you, times thank you!!

[dilippatil]

can somebody tell how to add space while it fixes line breaks?

[gergelysz]

Tiny but anoying problem. Super-useful! 🐱‍🏍Thanks for this video!

[pravinshingadia]

Brilliant video my friend! You helped me with a big problem today with annoying returns stopping data from being transformed correctly.

This solved the problem

[ScottPerley]

Thanks! Exactly what I was looking for

[victorial]

Is it possible to remove line break from just the second line of one box