rotation of fields

Originally Posted by whatswhat1

If I have a column of cells, such as: 1,2,3,4 ...... and I want to rotate the next group to: 2,3,4,1 ...... then: 3,4,1,2 .... and 4,1,2,3 ..... and so on.

second question

I'm getting an upload rejection using concatenate. I tried uploading a new column using =. Is there some way to convert the results of concatenate to actual numbers and letters.

Thanks for looking,

Dave

First question, and this is just a guess:

I'm going to assume the first cell of the group you want to rotate is in A1, and that there are 10 cells in the group. I'm going to assume you want the rotated cells starting in A11. You'll have to manipulate the following to your exact needs.

A11: = offset($A$1,Mod(1+row(A11)-row($A$11),10),0)

And fill down to A20.

For this, you'd replace the 1 with the amount you want to rotate it. The 10 refers to the number of items in the set you want to permutate.

Depending on how you set it up, it can automatically change the rotation. For example, if you had the first set at A11, then at A21, then at A31, etc, you could change the 1 to INT(ROW(A11),10) where 10 is as above and fill down as far as needed.

Second question:

I don't really understand what you are asking. Someone else might, or it might not hurt if you rephrased it. I'm don't understand what you mean by Upload.

Scott