Unique Combinations from 4 Columns

Hi

I'm new to the forums, so I apologize if it sounds like I'm posting a question that's already been answered! I've scoured the entire website trying to look for a macro (or function) that will create unique combinations from a given list in adjacent columns.

So basically, I have:

A 1 F1 R1
B 2 F2
C F3
D
E

And i'm trying to list all the information as (in the same worksheet and in different columns):

A 1 F1 R1
A 1 F2 R1
A 1 F3 R1
A 2 F1 R1
A 2 F2 R1
A 2 F3 R1
B 1 F1 R1
B 1 F2 R1
B 1 F3 R1
B 2 F1 R1
B 2 F2 R1
B 2 F3 R1
...etc.

(added bonus for being able to toggle where the list is printed on the sheet)

Please help!

Hey shg, unfortunately the website is blocked at work. Is there another website or perhaps could you attach the file to your post?

you're the best.<3

Hello There,

Very good macros, by any chance if you have time can you modify it in order to skip the cells that are blanks because they are counted in the combination.
The are cases here when some columns have blanks cells so the shouldn't be in the combination series .

Thanks for support

Also very strange, i don't know if is from my version of excel, I add a new value to one of the columns,the macros is taking the blanks in the combinations.

Here the link to the results
https://app.box.com/s/bh09cw8v8c2bf4xybkqw

I use excel 2013. i will change to 2010

Well is doing the same thing, should something wring with the excel configuration