Converting table with Dual Headers into standard table and pivot table

[ppatane]

I have a poorly setup table that I need to get to a standard table and a pivot table.  The 1st header row contains the year and quarter combined; the 2nd is the month and the 1st column header. It covers 3 years.

These are what the output needs to be.  I have done this with power query in Excel but need to now accomplish this in Alteryx.  Getting the pivot table is not as critical as getting the standard table.

[Yoshiro_Fujimori · Accepted solution]

Hi @ppatane ,

Here's one way of doing this.

Workflow

Standard Table

I needed "Month2" to sort the "Totals" table. You may remove with Select tool.

Totals Table

[geraldo]

@ppatane 

A workflow example without hardcode
year and quarter fields need to be created separately

The other suggestion is excellent @Yoshiro_Fujimori