Power Query To The Max - Splitting Multi-Lined Excel Cells In Power BI

In this video, I want to show you one way of how you can split multiline cells into multiple rows. Sometimes you’ll get an Excel file where data inside the cell is split across multiple lines, and that can be painstaking to work with. I’ll demonstrate how you can use and in a case as such. Melissa ***** Video Details ***** 00:00 Introduction 00:57 Carriage return and line feed 02:07 Splitting cells into multiple list items 04:13 Creating a set of value pairs 05:53 Projection 08:02 Splitting columns by delimiter ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - FREE COURSE - Ultimate Beginners Guide To DAX - FREE - Power BI Resources - FREE - 60 Page DAX Reference Guide Download - Enterprise DNA Membership - http