Transforming data set to desire format

[JiangLong96]

Hi,

Good days!!!!

I would like to know if is it possible to transform below data (Source data) to a desire format (Result) by using Alteryx?

Cash = 111
Trade Receivables = 112
Other receivables = 113 +114 +115 +116

PPE = 121 +122

Payables = 131 + 132 +133 +134

Source Data

	Description	A	B	Total
111	Cash	543,543	234	543,777
112	Receivables	1,325		1,325
113	Prepayment	345		345
114	Accrued	53		53
115	Advance	12	43	55
116	Deposit	3,453		3,453
110	Total asset	548,731	277	549,008
121	Motor	12,315	345	12,660
122	Depreciation	(21)	(46)	(67)
120	Total non-current	12,294	299	12,593
131	Payables	435	53	488
132	Loan	123		123
133	Accrual	3,425		3,425
134	Tax payables	123		123
130	Total payables	4,106	53	4,159

Result

Description		Total
Cash		543,777
Trade receivables		1,325
Other receivables		3,906
		549,008
PPE		12,593
		12,593
Payables		4,159
		4,159

Thanks in advance

[ArtApa]

@JiangLong96 - Here is a solution: