Attempting to sum Multiple Columns that meet a certain criteria (dynamic)

[tommyjohn342]

Prod #	Description	CG	Totals	5 SHP	5 MMS	5 Other	12 SHP	12 MMS	12 Other	14 SHP	14 MMS	14 Other
1	Apple	48	291	15			65			84	48	79
2	Orange	48	841		54	651	4		84	48
3	Pear	48	213	5			51	51	8			98
4	Banana	48	597		45		51		8		484	9
5	Pineapple	48	137	45			8		84
6	Grapes	48	101			1	4			48		48

I need help trying to combine columns that start with the same number (store number) into a single column.

For example. What is the sum of Orange for Store 5 (5 SHP + 5 MMS + 5 Other) ? 

Please note:

This has to be dynamic in the sense that I don't know what other stores will be added or taken away but the format will not change.

So if a store 16 shows up i know it will come in 3 columns and be laid out like (16 SHP, 16 MMS, 16 Other). I am just looking for a way to combine each column that is split into 3 columns currently so that the output is 1 single column with the sum of all 3 columns.

Please help me! I am very new to Alteryx. 

[Qiu · Accepted solution]

@tommyjohn342 

This is for sure dynamic

[tommyjohn342]

Thanks for taking the time to reply! This is where I was stuck as well. 

[Qiu]

@tommyjohn342 

Glad to help and thank you for the accept mark!