I know that you can create a list (i.e. Produce - Fruits, Vegetables, etc.)
and then a dependent list (i.e. Fruits -Apples, Oranges, etc.). But you have
to use two columns. For example, column A is data validated for the Produce
list and you choose Fruit. Then column B is data validated for the dependent
lists where you can choose Apple.

Is there anyway to do this without the use of column B and have everything
on column A? So basically, in column A, you would put your cursor over Fruit
in the drop down list and then a second drop down list would appear to the
right side of the drop down list and you can choose Apple and this would be
the selection in column A.