Ok so I have this form that has a list of text in column A and a "yes" "no" and "n/a" check boxes in column B. The form has already been filled out and I need to preserve the data while converting it to some format where I can work with it as a value or text. I know you can assign each box a cell and have it display TRUE or FALSE, but is there a way to do this in mass?

For example I have nearly 300 things on the list and I want to be able to assign yes to column C, no to D and n/a to E for the first item in column A. But then those are treated like text and not a formula so I cannot just drag each of those boxes down to repeat that for each of the entries on the list.

Basically, I am looking for a way to assign boxes to columns in mass rather than individually 900 times.

Thanks