Formula to move to specific column

[tmaxx43]

I have spreadsheet with column numbers labeled 1,2,3, etc. and the row
are also labeled 1,2,3, etc. I have a set of numbers in adjoining cell
in a row, say 2,4,6,8,10, but they can be any two digit numbers.

What I would like to do is have a formula that takes the first number
2, and move to the column 2, and put the 2 in that cell. Then take th
number 4, and move to column 4, and put the 4 in that cell, and so on.

Any help would be greatly appreciated

 

[Vasant Nanavati]

I'm not clear on what you are trying to do. It seems that you could
accomplish what you want by inserting blank columns in between the populated
columns.

Formulas can't "move" numbers from one location to another. For that you
need a macro.

 

[tmaxx43]

What I'm trying to do is to move the active cell to the right based on
number in a different cell. In other words, if the number in a cell i
2, I want to be able to move the active cell two columns to the right
The number can be any two digit number, so that's why I'm havin
trouble with it

 

[Vasant Nanavati]

As I said, a formula cannot move a cell. You would need a macro to do that,
and much more precise information is needed to provide a basis for writing a
macro.