I have a groups of 6 cells that are in column A (A1, A2, A3, A4, A5,A6). I
want to change the 6 cells in column A to create new columns B1,C1,D1,E1,F1 &
G1. Then the second set of 6 cells in A (A7,A8,A9,A10,A11,A12) become
B2,C2,D2,E2,F2 & G2) and so on. I am using Excell 2007. Let me know if this
can be done