Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Lisa
it is working. thanks so much.