How can I transfer these columns of numbers without disturbing the columns of infill colours?

Question

I use 100 columns,,,,,,each set of ten columns is a different infill colour,,,,,,,I am transferring different columns of numbers to other columns,,,,,,,QUESTION,,,,,,,How can i transfer these columns of numbers without disturbing the columns of infill colours. These columns of infill colours must remain static while i am moving the columns of numbers backwords and forwards........very best regards Jim

Answer 1

One possible solution is to select and copy only the cells with the numbers (not the entire columns), then paste them to the desired destination while using the "Transpose" option, which will switch rows and columns. This way, the infill colors should remain static.