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!
Hi Andre,
Would be good if you could attach your file.
Sorry! I attached the file but occurred some problem. I'll try again. 🙂
Thanks.
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.
Thank you very much! This solution was very clever for me.
Glad I could help!
