I need to transpose 3 sets of numbers (col.A, C and E) in groups according to a filter column where groups of equal numbers determine precisely which set of numbers to copy each time.
For example... first must be analyzed col B then copy group of number of col.A every 3 columns starting from I1
then will be analyzed colum D and groups of numbers of col.C will be copied starting from J1..every 3 colums
the last check will be done on col.F and groups of numbers of col.E will be copied starting from K1..every 3 colums
I hope that with the help of the attached image everything is clear
thanks for any kind of support
For example... first must be analyzed col B then copy group of number of col.A every 3 columns starting from I1
then will be analyzed colum D and groups of numbers of col.C will be copied starting from J1..every 3 colums
the last check will be done on col.F and groups of numbers of col.E will be copied starting from K1..every 3 colums
I hope that with the help of the attached image everything is clear
thanks for any kind of support