In this video, I want to show you one way of how you can split multiline cells into multiple rows. Sometimes you\u2019ll get an Excel file where data inside the cell is split across multiple lines, and that can be painstaking to work with. I\u2019ll demonstrate how you can use Text.Split and List.Zip in a case as such.<\/p>\n
Melissa<\/p>\n
***** Video Details *****
\n00:00 Introduction
\n00:57 Carriage return and line feed
\n02:07 Splitting cells into multiple list items
\n04:13 Creating a set of value pairs
\n05:53 Projection
\n08:02 Splitting columns by delimiter<\/p>\n
***** Learning Power BI? ***** #EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerQuery #PowerQueryTutorial<\/p>\n","protected":false},"excerpt":{"rendered":" In this video, I want to show you one way of how you can split multiline cells into multiple rows. Sometimes you\u2019ll get an Excel file where data inside the cell is split across multiple lines, and that can be<\/p>\n","protected":false},"author":3,"featured_media":2723,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[137],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2021\/08\/EqT9b2XQyE.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-HT","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2721"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=2721"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2721\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/2723"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=2721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=2721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=2721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nFREE COURSE – Ultimate Beginners Guide To Power BI – http:\/\/portal.enterprisedna.co\/p\/ultimate-beginners-guide-to-power-bi<\/a>
\nFREE COURSE – Ultimate Beginners Guide To DAX – http:\/\/portal.enterprisedna.co\/p\/ultimate-beginners-guide-to-dax<\/a>
\nFREE – Power BI Resources – http:\/\/enterprisedna.co\/power-bi-resources<\/a>
\nFREE – 60 Page DAX Reference Guide Download – https:\/\/enterprisedna.co\/dax-formula-reference-guide-download\/<\/a>
\nEnterprise DNA Membership – https:\/\/enterprisedna.co\/membership<\/a>
\nEnterprise DNA Online – http:\/\/portal.enterprisedna.co\/<\/a>
\nEnterprise DNA Events – https:\/\/enterprisedna.co\/enterprise-dna-events-page\/<\/a><\/p>\n