Thread: Creating one column from multiple columns?

Hi,
I was wondering if there was a formula I could use to create one column from multiple columns. I.e I have three columns with 'monocular' 'binocular' and 'left/right' respectively, with 'true' or 'false' appearing in the monocular and binocular columns (mutually exclusive, cant be true or false in both), and 'left' or 'right' in the 'left/right' column. I want to create one column that will say whether it is monocular left, monocular right, binocular left or binocular right. e.g;

Currently it is;

Monocular Binocular Left/right
TRUE FALSE LEFT
TRUE FALSE RIGHT
FALSE TRUE RIGHT
TRUE FALSE LEFT
FALSE TRUE LEFT

I want it to go to (one column);

MONOCULAR LEFT
MONOCULAR RIGHT
BINOCULAR RIGHT
MONOCULAR LEFT
BINOCULAR LEFT

I have thousands of rows to do so it will take days manually!
Thank you in advance,
Kate

That didn't come out like I wanted!!The first e.g is meant to be spaced apart, imagine it in 3 columns of 'monocular' 'binocular' and 'left/right' with the true/false/left etc underneath...