Tag: Character Escape Sequences

Power BI Column Split Power Query Tutorial: How To Split Multi-Lined Excel Cells In Power BI

Power Query Tutorial: How To Split Multi-Lined Excel Cells In Power BI

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

Continue reading