All,
I have a spreadsheet with 2 columns. I want to combine/meld these two into a third/fourth column so that all items/combinations are created. That is, A1 shows with All items in Column B and is rendered in columns C and D. Please have a look at the sample I have attached which shows a short list that I created using copy and paste...the real data I work with is 100-1000's of items so copy and pasting gives me carpal tunnel just thinking about doing it. I am thinking it could be done by formula (I know how to copy and paste VB, that's it) and am looking for advice on if and how this could be done.

Thanks for you time/attention/help/snide remarks
compile_list_test.xlsx

Drew