I have a large spreadsheet in which cells have either a 0/1/2. I need to have Excel find cells with a 1 then place the name of the label for the column that 1 is in in a cell at the end of the row. Each row has multiple 1s in it, so that cell at the end would need to have data like this in it: "label 1; label 3; label 4; label 7." How can I do this?
Solved by T. H. in 21 mins