Help question

[WWII]

I have a column of text data that has random data. (e.g.-a1, a10, a34,...)
I want to set a2-a9 equal to a1, a11-a33 equal to a10, etc. How can I do
this?

Thanks.

W Weldin

 

[Don P]

If I understand you correctly you want cells A2 thru A9 equal to the first
random text in your column and cells A11 thru A33 equal to the second random
text in the column. But then you say etc. I don't see a pattern here for the
etc. If all you want is to have A2 thru A9 equal the first random text then;

Random text in column B2 to B5
In cell A2 enter =$B$2
Then copy the formula down to A9

Do the same for A11 thru A33 and text cell $B$3

I may have missed the mark entirely. If so try explaining with a table (row
and columns).

Don Pistulka