From the course: Excel: Power Query (Get & Transform)
Join today to access over 23,100 courses taught by industry experts.
Merging inconsistent data with a transformation table - Microsoft Excel Tutorial
From the course: Excel: Power Query (Get & Transform)
Merging inconsistent data with a transformation table
These two datasets need to be merged. Specifically, look at Liliya who volunteered five hours at the City Center location. We want to bring over Christine and the State Street address next to Liliya. Happy volunteered five hours at the Old Town location. We need to bring over Levi and the Davis Street information. But look at the data. There's some inconsistencies. There's Downtown, where James volunteered. Downtown is formally called City Center, and we would like to have some consistency because that will allow us to do some analysis later. Notice Maya, NW, that should be Northwest. Happy enrolled 13 North West. Okay. Back in the bad old days, we would have to go through and clean this up. But we've got Power Query. And notice this. I'm going to unhide. And if you're following along, please unhide this as well. We have what's called a transformation table. It is going to allow us, where you see Downtown, it will see City Center and bring Christine and State Street over anyway…
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.