
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
1 Guest(s)
