As a late entrant to using lambda
s 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