From the course: Advanced Power Query
Join today to access over 24,600 courses taught by industry experts.
Handling double headers
From the course: Advanced Power Query
Handling double headers
- [Narrator] A very common but not a good practice is to add double headers to the data while working with Excel, which makes it very, very hard to analyze that, because the data has got two dimensions now. Can we fix the double headers problem using Power Query? Of course, beyond the user interface is something that I will teach you in this video. Let's start. Alright, let's just start with the problem. We have two headers in the data. We have the Main header as Category, and Revenue, and then the subheaders as Main, and Sub, and Pre Tax, and Post Tax. Now, we would like to concatenate the headers and bring them into a single row. Let me show you the solution that I have prepared on the right? You can see that here we have the headers concatenated, Category|Main, Category|Sub, There is also a delimiter in between Revenue|Pre Tax and Revenue|Post Tax. And that's how our data should actually look like. Now it doesn't concern us that what the header is, how many subheaders are there, no…
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.