Insert value from different input with same name multiple times

[npacheco]

Hi folks, looking for some help on this one.

I have ~4000 companies with ID's and each of them has a number of "Criteria" with a 0, 1, or NULL value. The criteria have their own ID's: (E01, E02, etc).

I have a separate file that contains "weights" for each of these criteria. A numeric value between 0 and 10.

For each "1" found in each Criteria of each company, I need to replace it with the relevant weight of that criteria. 

It's a little difficult to explain so hopefully the attached demo file with expected output will help.

Would appreciate any and all help with this. Thanks!

[binu_acs · Accepted solution]

@npacheco one way of doing this

[npacheco]

Thank! That'll do it.