I have a spreadsheet that shows a persons details including 3 columns that contain their 1st, 2nd and 3rd choice of desired location (O, P and Q).

I would like to be able to filter the spreadsheet to display everyone who has selected the location in question, regardless of which of the 3 columns it is in.