Zend certified PHP/Magento developer

How to use excel lambdas and/or array formulas to generate the cross-product of two arrays?

As a late entrant to using lambdas with excel, I”m extremely excited to see how they can simplify my company’s sheets.

One area we would love to see simplified: we have a list of values that look like:

Sites Values
Site1 Value1
Site2 Value2
Site3 Value3
Site4
Site5

I would love to have some excel code that, regardless of how many sites and values there are, would be able to generate a cross-product table, eg.

Site Value
Site 1 Value 1
Site 1 Value 2
Site 1 Value 3
Site 1 Value 4
..
Site 2 Value 1
Site 2 Value 2
Site 2 Value 3
Site 2 Value 4

Is there a way to do this in direct excel formulas, i.e. (a) no macros, and (b) nothing that maintainers will have to click on/manually do every time we add a new site?

Thanks!
/YGA