Is there a way to combine 2 columns?
For example, I have a survey asking a Yes/No question. But the survey puts all yes’ in one column, and no’s in another. So it will look like
column 1 column 2 yes yes no yes no no yes
And I want it to look like
column 1 yes yes no yes no no yes
Merging will delete one of the columns...and that's about all I know. Hopefully it won't involve VBA since I don't know any of that.