Create a table of unique options from another table

I really apologise for the title however I was struggling to think how to better describe the problem (suggestions welcomed).

I have attached a sample worksheet to illustrate I have a table of information where a number of columns show the options available.
I need to extract from this the second layout which shows each option that applies on a separate row.

Is the any way to do this without VBA?
If not, I will repost in that section.

Fingers crossed!

Andrew

If not, I will repost in that section.

No, you won't. If necessary, I will move the thread for you, but duplicate threads are against the forum rules.

Here's a PowerQuery solution.

M Code (all UI clicks):

Please Login or Register  to view this content.

You would not have been able to - so for future reference, if you ever need to move a thread, you must contact one of us and ask us to move it for you.

Originally Posted by AliGW

Here's a PowerQuery solution.

That is awesome, I have been starting to get to grips with Power Query and that is great to know.

Many thanks

You're welcome. I would go with Fluff's formula, though.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.