Log In
Register
Home
Active Member
July 21, 2022
Offline
Hi. My name's Andre. I'm from Brazil. I am having a problem with Power Query. I have a sheet that contains some columns with header and data, that's ok...but some columns have two headers and two kind of the respective data below them. How can I separate this colums in two columns?
Thanks for the help!
See Answer
Trusted Members
Moderators
January 31, 2022
Online
Hi Andre,
Would be good if you could attach your file.
Active Member
July 21, 2022
Offline
Sorry! I attached the file but occurred some problem. I'll try again. 🙂
Thanks.
Trusted Members
Moderators
January 31, 2022
Online
Thanks for the file. I added a few queries that create two sub-sets of the data. One for the the odd numbered rows (group1) and one for the even numbered rows (group2). Promote the headers in each of these groups. Append as new (Output), remove unwanted columns , sort, fill, filter, reorder and clean-up a bit.
Perhaps there are more elegant ways to achieve this but this is all I could think of right now.
Answers Post
1 Guest(s)
