Layout Excel Pivot Table - Group Columns

[aurzuao]

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! 

[KimLamNg]

@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...)

Spoiler

[aurzuao]

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.

[KimLamNg]

I don't think you can have columns within a column in Alteryx. The workaround is to use reporting tools. You can play around to hide the column name of the second column when you render the data, which visually looks like the desired format.

[aurzuao]

Hi, yes, that is my understanding, that's why I mentioned the layout, Is there a way to use the reporting tools to accomplish this ?