Forum Discussion
Solved
Group columns on pivot table
Hello to every one, I've been trying to group certain columns depending on a value. I have this table: PRODUCT FLOW PERIOD DECLARANT PARTNER QUANTITY VALUE 1...
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.
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.