Yes, I am trying to make an alphanumeric string.
Column 1(C1) has one value 'A' this will be in location Column1 Row1 (C1R1),
Column 2 (C2) has multiple values, let me use 4 values '1,2,3,4'
1 (C2R1), 2 (C2R2), 3 (C2R3), 4 (C2R4)
Column 3(C3) has multiple vaules, let me use 6 values 'BB, CC, DD, EE, FF, GG'
BB (C3R1), CC (C3R2), DD (C3R3), EE (C3R4), FF (C3R5), GG (C3R6)
I want to create a string like this:
C1R1 C2R1 C3R1 = A1BB
C1R1 C2R1 C3R2 = A1CC
C1R1 C2R1 C3R3 = A1DD
C1R1 C2R1 C3R4 = A1EE
C1R1 C2R1 C3R5 = A1FF
C1R1 C2R1 C3R6 = A1GG
C1R1 C2R2 C3R1 = A2BB
C1R1 C2R2 C3R2 = A2CC
This will continue unitl the final string is created A4GG
The first value will stay the same A, the second vaule will change only after the last value it the couln following is completed.
Please let me know if this is easier to understand.
Thanks for the help.