I need to determine all permutations of a data set organized like this please:
Place 1 Place 2
.... through ... Place 14
Amount A Amount B Amount C
Amount D Amount D Amount E
Amount F Amount G Amount H
Where the output has one 'Amount' from each Place, but not necessarily each Row.
(e.g. A result could have the Row 1 'Amount' for Place 1-13, and Row 2 'Amount' for Place 14, with no result from Row 3)
See attached for example data set to work with.
I'm comfortable importing/using Macros, just not very good at writing them.
If it would be better to use Access, please advise on a proposed solution for that as well please.