Greetings, is it possible to transform a table into a pivot table? It is necessary to group tow columns into another one (nest them) Example:
Input Data:
Desire output:
Excel pivot table config:
Any idea would be appreciated. Many thanks!
@aurzuao Here is one way to do this. You will need to add some more tools to make it look exactly the way you want it (sort month, rename column names, etc...)
Hi, the actual need is to design the table to have two columns within another column on the layout, this is helpful but is not formatting the table as desired, thanks.
