From the course: Excel Power Query Tips and Techniques
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Rename column
- [Instructor] When we're working with Power Query, it helps to have meaningful column headers, and it does a lot for us. It automates things, but watch. It's going to make generic column headers that we're going to fix, so right now we have members, their IDs, and their cities all in one cell. We've got to split 'em out. Okay, the column is highlighted. Now we want to Split Column, and we're going to split out the city first. Split Column by Delimiter. Let's split by the semicolon first, so we can get the city out. Okay, notice it's made up this column header Member, ID, City.2. That's not what we want, so we're going to double click. Call this City, Enter. And then let's split out the ID. Highlight this column. Split Column by Delimiter. And we're going to split by the space, and we're going to split by the rightmost delimiter. Okay, now the IDs are split out, and we've got this generic header. Double click…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.