Join 2 Cross Tables

[GraceGao]

Hi Experts

i have one by months excel table fields like below.

Region, Jan....Dec(Qty),Jan...Dec(Amount)

i would like to cross table like below result.

expected result: Region, Month, Qty, Amount.

i thought cross table twice and join table, but this is  not working. Illegal error prompt. 

could anyone to help me ? Thanks in advance.

[Lisa_P]

You cannot apply join as well as crosstable together. You can do a load resident on the second table with a join and then drop original second table.

[GraceGao]

Hi Lisa

it is working. thanks so much.