power query split rows

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.

AI Chatbot Avatar
⚠️ Welcome to our chatbot! Please note that this chatbot is designed to provide general information about our Excel and Power BI courses, and should not be relied upon as legal or financial advice. Any personal information collected by the chatbot will be handled in accordance with our privacy policy. By interacting with the chatbot, you agree to our terms and conditions.