Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
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/powerquery/split-into-rows

Related Videos:

Power Query Overview - Automate Data Tasks in Excel & Power BI:
https://www.youtube.com/watch?v=vq9AgAtSvQg
How to Combine Excel Tables or Worksheets with Power Query:
https://www.youtube.com/watch?v=HcfKOusOJhA&t=43s

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