Auto generating list

I am trying to setup a excel spreadsheet that when a certain letter is inserted into a cell then it will generate a list based on that value.

An example is im setting up a product.
This product can have different colour variations.
The product code will be

TABLE/B - for a black table

TABLE/w - for a white table

I want the "Table" and "Black" to be in separate columns.

In the "table" part there is
-top
-legs
-screws

In the black "component" there is
-Black paint

In the Grey "component" there is
-Grey paint

What I am trying to achieve is that if lets say column A1 has the word TABLE in it then and A2 has B in it the list shall be-
-top
-legs
-screws
-Black paint

But if I change A2 to grey then Black will be replaced with-
-Grey Paint

Glenn,

You`re a genius.

Thanks for your help!

Sorry to be a pain,

How would you go about adding a quantity column that will pull through if a value is met?

Had a feeling it would be simple.

Thankyou for you help!