Drag Down Certain Cells (Not Increment By 1)

  • Thread starter Thread starter five0s
  • Start date Start date
F

five0s

I have a spreadsheet that has a huge amount of data that is ordered
funny, but in an ordered manner. I wanted to connect the cells
together to get them to appear in a sensible manner. When I got a few
of the cells the way I wanted them to look, I then selected a few of
them and drug the handle down, but it would only increment by one, it
did not pick up, that it needed to skip each cell by 14 rows, it just
did it by one.

Screen shot of what I have that looks right, how do I apply all the
way down, without manually typing the pattern in?
http://img205.imageshack.us/img205/3803/picture1kmt.png
 
Hi

Try
=INDEX(A:A,(ROW()-1)*14+4)&" "
&INDEX(A:A,(ROW()-1)*14+7)&" "
&INDEX(A:A,(ROW()-1)*14+1)&" - "
&INDEX(A:A,(ROW()-1)*14+10)&", "
&INDEX(A:A,(ROW()-1)*14+13)

The formula is all one continuous line, but I have forced it to break at the
points shown to ensure that your newsreader doesn't break it in an
inappropritae point.
 
Back
Top