Cross tab for multiple columns?

Question

Hi, I am new to Alteryx and would like to do the following summation but not sure how to use cross tab tool with multiple columns - can anyone assist? Thank you

Country

ID

code 1

%

code 2

%

X

1

A

100%

-

X

2

B

0%

D

100%

X

3

D

80%

A

20%

X

4

B

70%

D

30%

X

5

A

20%

B

80%

To new format as below

Code

ID

A

140%

B

150%

C

0

D

210%

BrandonB · Accepted Answer

Example solution taking select tools for each code/percent column, renaming them, then unioning them to stack and finally a summarize tool: