Dummy Data.xlsx

I've attached the file, I hope it helps with my explanation.

I don't want to just check where there are 1's or 0, but if I find a number put a 1 in it's location.

Thanks,
Brendan