Cross tab for multiple columns?

[tara]

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 solution]

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

[tara]

Great thank you!