Using Power Query for Text to Columns and Rows - CRUSHES Excel!
In Excel, you have tools like Text to Columns, and text functions like LEFT, RIGHT, and MID, and the ability to create macros. None of them are as powerful and useful as Power Query. In this video, we use a simple delimiter, we use Non-Digits to Digits, and we break a column into multiple rows.