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 Text.Split and List.Zip 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 – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerQuery #PowerQueryTutorial