How to add SKILL numbers-CodePudding

I want to put numbers like 1N4 type text in the box which will indicate that 1 person has 4 level skill . for example in row 16 , 1N1 means 1 person wth skill 1 , 1N3 means 1 person with skill3 and 1N4 means 1 person with skill 4 .

I need to fill Skill column by looking into XYT column data .

So far I do this manually can we add some formula to make this ?

After my attempt I am able to do this , but I need small help

I want to hide the values which has 0 in starting . How can I do that ?

CodePudding user response：

There are many ways in doing this, here is one:

Formula in A1:

=TEXTJOIN(" ",,LET(X,SEQUENCE(4),Y,COUNTIF(B1:D1,X),FILTER(Y&"N"&X,Y)))

Or, if you want to do this in a single go for the entire range:

Formula in A1:

=BYROW(B1:D5,LAMBDA(z,LET(X,SEQUENCE(4),Y,MMULT(--(z=X),{1,1,1}),TEXTJOIN(" ",,FILTER(Y&"N"&X,Y)))))