Hi,

I have a little job to do which involves testing different software,
harvesting the results and getting the data displayed in a pivot table.

There are 4 softwares,
For each softtware there are 2 different configs,
For each config there are 3 different actions,
For each action there are 3 different tests.


I can handle setting up the pivot table from the data, but I need to get the elements of the table
and all possible permutations into a list for data validation so the tester would then just have to choose a test from a drop down validation list and then key in the result for that test.
That list would be the base of a pivot table.


(This kind of problem rears it head in a variety of situations and it has always made ma wonder why Excel is so good a making pivot tables from lists and - apparently - useless at making lists from tables.)



Is there some smart way of getting XL to make a list of permutations from a table of elements ? or would I have to make a VBA thing that would produce a list using nested loops ?



This is what I have :

Elements

Software Config Action Test

TTT alpha print a

AAA beta visu b

OOO delete c

ZZZ



This is what I need :

List

Test

TTT alpha print a

TTT alpha print b

TTT alpha print c

TTT alpha visu a

TTT alpha visu b

TTT alpha visu c

TTT alpha delete a

TTT alpha delete b

TTT alpha delete c

TTT beta print a

TTT beta print b

TTT beta print c

TTT beta visu a

TTT beta visu b

TTT beta visu c

TTT beta delete a

TTT beta delete b

TTT beta delete c

AAA alpha print a

AAA alpha print b

AAA alpha print c

AAA alpha visu a

AAA alpha visu b

AAA alpha visu c

AAA alpha delete a

AAA alpha delete b

AAA alpha delete c

AAA beta print a

AAA beta print b

AAA beta print c

AAA beta visu a

AAA beta visu b

AAA beta visu c

AAA beta delete a

AAA beta delete b

AAA beta delete c

etc...



TIA

Lucy