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