Split Data Into Rows Using Power Query

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
In this video, you’ll earn how to use Power Query to convert a string of names and email addresses into a formatted table. This video covers how to use the Split by Delimiter into Rows and Columns features of Power Query, and how to trim blank spaces and replace values. Create a fully automated system that can be reused anytime on a new list/string of text.

If you’d like to read the accompanying blog post on my website, you can access it here: https://www.excelcampus.com/powerquer...

Related Videos:

Power Query Overview - Automate Data Tasks in Excel & Power BI:
   • How To Automate Data Tasks In Excel U...  
How to Combine Excel Tables or Worksheets with Power Query:
   • How To Combine Excel Tables And Works...  

#MsExcel #ExcelCampus
00:00 Introduction
00:54 Split Data
06:25 Data Cleanup