Power Platform Tutorials In this power query tutorial, I want to show you one way of splitting multiline cells into multiple rows. Sometimes you will get an Excel file where data inside the cell is split across multiple lines. Today, I want to show you how you can use Text.Split and List.Zip to help you
For this tutorial, I’m going to demonstrate how you can extract values before each occurrence of a specific text using Power Query Advanced Editor. There are many ways to achieve this, but I thought it would be fun to show a solution that’s fully coded. You can watch the full video of this tutorial at
