All Combinations Two Columns

dssebrin

Need to a way to find all combinations using two columns.  See the attached data set.  I've included what the input looks like in tab 1 along with what the desired output would look like in tab 2.  Basically for each store I want every possible combination of geo.

Thanks in advance for your help!

Dan

sample data.xlsx

OllieClarke

Hi @dssebrin this does what you want:

hope that helps,

Ollie

dssebrin.yxmd