Active Member
July 21, 2022
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!
Trusted Members
Moderators
January 31, 2022
Trusted Members
Moderators
January 31, 2022
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