Populating List from Table

Hi Everyone,

I want to be able for Excel to populate into a list format from a table where 'X' is marking the item. I've attached a test so you can see. So you can see in cell D2 there is 'X' marked.

Down below you can see the result I am after. It is a concatenation of the X & Y axis along with the column B.

Any ideas?