Going Text to ROWS with Power Query
Text to Columns is a common tool in Excel (although the Text to Columns feature in Power Query, called Split Column, is much better). However, there are some situations where Text to Columns doesn’t do the job we need it to. In this video, we go Text to Rows – creating new records for each entry in a given cell. Depending on who’s doing your data entry, this might be the thing that saves your day.
Related everyday office posts
Building a Color-Coded Calendar Grid in Excel
People are always badmouthing Excel and working in various new and powerful data visualization tools. In this video, we duplicate...
In this video, we compare your standard use of VLOOKUP – combining two tables – with the Left Outer Join...
Related recources
A Beginner’s Guide to Power Query
Power Query is Excel's new ETL tool - whether you’re talking about Excel or Power BI, when you extract, transform, and load the data into a report, you’re doing it with Power Query.