exchange columns according to some map regarding pairs of numbers

K

Kanghyun Choi

I am using Excel to record some data.
In the first row I typed in pairs of numbers 1_1, 1_2 ,...1_18,2_1,2_2,...,2_18,3_1,3_2,...,3_18...,...,18_1,18_2,...18_18.
So there are 18 times 18 values in the first row.
Each pair n_n is located at the top of each column. Each column has 9 values(rows) not including the pair n_n.

Let f:{1,2,...8}-->{9,10,...,16} be a one to one map given by f(x)=x+8.
Let g:{n_n : 0<n<9 integers}-->{n_n : 0<n<9 integers} be the corresponding one to one map which sends 17 to 17 and 18 to 18. Each pair n_n represents one column. What is the best way to exchange columns according to the map g?. Is there a better way to copy and paste them?
 
K

Kanghyun Choi

g is a one to one map from {n_n : 0<n<19 integers}-->{n_n : 0<n<19 integers} constructed from the map f , inverse of f, and 17-->17, and 18-->18.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top