From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Power Query split and pivot

Power Query split and pivot - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Power Query split and pivot

“

- [Instructor] You ready for some Power Query? I hope so. We have these assignments and they need to be split out. Let's look at Martina in January. Martina is assigned to London. In February, Martina is assigned to Dallas. There's a colon after each name, there's a semicolon between each month's assignment and there's a comma between the month and the city that each person is assigned to. The goal with this data is to have it look like this. The results should have an assigned column with the names and then January, February, March as headers so that you can look and see that Carlisle is in Hong Kong in February. And once you've got all of that working, add at least one more row to the assignments data and make some April assignments, then refresh to make sure everything works. All right, pause the video, power through this Power Query challenge, come on back and I will show you how it's done. (upbeat jazz music)…

Contents