I have six columns and 15,625 rows. My data is working with combinations of 1 - 5.
In column A, I want to sequence my input data as 1,2,3,4,5 and then 1,2,3,4,5 etc until row 15,625
In column B, I want to sequence it as five 1s, then five 2s, then five 3s, then five 4s, then five 5s.
In column C, I want to sequence it as 25 1s, then 25 2s, then 25 3s, then 25 4s, then 25 5s.
In column D, I want to sequence it as 125 1s, then 125 2s, then 125 3s, then 125 4s, then 125 5s.
In column E, I want to sequence it as 625 1s, then 625 2s, then 625 3s, then 625 4s, then 625 5s.
In column F, I want to sequence it as 3,125 1s, then 3,125 2s, then 3,125 3s, then 3,125 4s, then 3,125 5s.
This will create a permutations matrix of 15,625 outcomes of six questions with 5 answers each.
Hope someone can help me! Tearing my hair out here!
Bookmarks