Excel – Every combination of column a and column b into column d and e

microsoft excel

I'm not really sure how to even ask this question. So I took a screenshot of what I'm trying to accomplish.

enter image description here

I'd like to output every combination of columns a and b into column d and e. I've seen many examples of how to combine a and b into one column, but I need them into separate columns.

I'm sure this is possible, I just don't know what to even search for to start

Best Answer

Two formula.

Put this in D1 and copy down:


Put this in E1 and copy down:


enter image description here