Forum Discussion
Group columns on pivot table
Hi ciervax
I tried JW_van_Holst 's solution and create a pivot table like below. The output is the same as your expected result. Is this what you want?
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
if you upload a copiable table, could, perhaps, get you a quicker response.
Sure, I've edited the post, I tried the first time to do it, but the second table was not showing properly, cause some fields are combined, I don't know if there is any other option.
in power query it is not possible, as far as i know, to have two columns with the same name in merged cells (like in excel).
So this is, in my opinion, the one that comes closest to the layout you are looking for.
Prova e facci sapere.