Converting table with Dual Headers into standard table and pivot table

Question

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.

Upload.xlsx

Yoshiro_Fujimori · Accepted Answer

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