Split multiple lines in one cell into multiple rows

The most interesting part of training is helping my learners solve their problems in Excel.

In this course title “Secret Hacks of Excel Data Analytics for PMET”, I was asked if I could help to split the lines all captured into one cell into multiple rows so that auto-filter and checking can become a lot easier.

And I did it with Power Query, one of the topics covered in the course.

Watch the video to find out how it is done.