Friends!

Is there any way I could create a dropdown list within one cell (without having to select a range of cells to create a dropdown list)

Now, this particular cell should have the ability to extend if new data is entered into it.

For example, I will enter a name, say, Apple.

The dropdown list should be Apple only.

Now, I will add, say, Orange, Banana, or Kiwi.

If I open the dropdown list it should show all these in it.

Now, again, this should be done within one cell and without having to select a range of cells in order to create this list.

I hope I am explaining thoroughly and I really hope someone could help me out, please.