I have a list of four independent variables (sugar concentration, type of sugar, starting pH, and temperature), and I want to test their effect on yield of a product in an upcoming experiment. Each has three levels, and I’ll be doing three replicates of each condition. What I’m trying to do is create a table (array?) of all the samples based on these variables (should be 243 samples in total – 3^4 * 3 replicates). For example, sample 1 would be 20, Glucose, 5, 1, 28, and the list would continue until each combination of variables has been included. How can I do this in Excel?