Help with transform data

[hylosko]

Hello experts !

it is possible to do from this :

this

the important thing in this logic is that:

5 = A

3 = B

0 = C

in final table we have counts of that values for example in A if in CAT 1 we have 5 times value A in column CAT - A we will be have 5, etc 

[CNENFRNL · Accepted solution]

= Table.ReplaceValue(#"Changed Type",null,null,(x,y,z) => List.ReplaceMatchingItems({x},{{5,"A"},{3,"B"},{0,"C"}}){0},Table.ColumnNames(#"Changed Type"))

= Table.ReplaceValue(#"Changed Type",null,null,(x,y,z) => try {"A","B","C"}{List.PositionOf({5,3,0},x,0)} otherwise x,Table.ColumnNames(#"Changed Type"))