How to separate data with multiple lines of data per cell

If you have have a dataset, where randomly within your data there are cells with line breaks between data, and you want each one of those lines to be in their own cells, this is the best way I've found to fix this. Unfortunately, it is a multiple step process, but it's the fastest way i found out how.

[@kushagraverma]

thank you for sharing this. absolutely incredible.

[@BrianLeeDick]

Glad you found it, hopefully this solved your issue faster than it took me to figure it out

[@rachaelstacey1401]

Why 10 please?

[@BrianLeeDick]

Why CHAR(10)?