I have a problem I am not sure is possible even though it sounds like it should be. I have three values in three rows giving 27 combinations and them combinations are covered in columns A,B & C. I have to have seven columns so you can pick any three of them and have all combinations. so column D would have to have the values placed to link with A,B: A, C: & B,C so placement has to be right. If this is not possible I would like to know how far it is possible to go doing this but also I have to do the back up idea and do it as a rolling combination, A,B,C; B,C,D: C,D,E etc

A B C D E F G
X X X
X X Y
X X Z
X Y X
X Y Y
X Y Z
X Z X
X Z Y
X Z Z
Y X X
Y X Y
Y X Z
Y Y X
Y Y Y
Y Y Z
Y Z X
Y Z Y
Y Z Z
Z X X
Z X Y
Z X Z
Z Y X
Z Y Y
Z Y Z
Z Z X
Z Z Y
Z Z Z