Drop-down help

I would like to create a drop down option for a column on a worksheet, let's say column G.  For each row, there can be multiple entries in the G column, say 'apple', 'orange', 'grape'.  There may be only one fruit or more than one fruit.  Can I establish a tab in the header row on G so that the user can select 'apple' and then the worksheet will show only those rows with 'apple'?  This is very much like filtering, but having a permanent, built-in filter just for that column.  Please advise; thank you.