Sum one column based on unique entries in multiple columns

[Anonymous]

I have a Table with repeating text values in multiple columns, I then have a single column with values, 
How can I sum the total of the individual texts?

A, B, C, 5, 

A, C, C, 10, 
A, A, B, 15, 

Sum of A = 45

Sum of B = 20

Sum of C = 25

[MattAllington · Accepted solution]

In power query,

select the integer column

Right click, unpivot other columns. I think this will give you 3 columns, but you only need 2

Load the data

place The  column of letters on rows of a table and the integer column on values