Home » Education » Split Data Into Rows Using Power Query

Split Data Into Rows Using Power Query

Written By Excel Campus - Jon on Thursday, Nov 05, 2020 | 07:00 AM

 
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

Disclaimer:
All images, musics and videos copyright are belong to their respective owners. We just put embed contents from Youtube.com and do not host any content in our server. These content(s) may be protected by copyright law or other laws regarding intellectual property of the United States or other countries. Downloading file(s) on this site is just for review purpose. If you love the song, please support the artists by buying the original CD/Cassette or buying the song from iTunes.