From the course: Advanced Power Query
Join today to access over 24,600 courses taught by industry experts.
Challenge: Remove junk column names
From the course: Advanced Power Query
Challenge: Remove junk column names
(upbeat music) - [Instructor] You've already learned the fundamentals of how lists are created, and a couple of examples of how do we use that concepts to solve practical problems. It's time now for you to solve a problem. Are you ready? Okay, I'm working in this Excel file, and that's where I have given you some data to work with. You can see that we have some standard columns, name, email, but then the email also gets duplicated one more time because this is a junk column, and the way to be able to identify a junk column is that it's going to have this little till sign at the end of it. And then we move on. We have a phone number column. This is a legit column, but in case the phone number column gets repeated with some junk entries right here, you're going to see that it is going to have a till sign and then two till sign here, so on and so forth. Again, if you take a look, we have the address column, and then the address column again gets duplicated with some junk values, and this…
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.