Drag Down Certain Cells (Not Increment By 1)

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
 
R

Roger Govier

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.
 

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

Similar Threads

drag down, not by series 4
Increment Forumula Series by 4 each row 8
increment cells in repeating formulas by something other than 1 8
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do I increment a cell by 1 using a form button? 3
Restrict Choice in Shared WB (drop down alternative)? 0
Button that will increment by 1 2
Excel Data pastes into 2 cells not 1 1

Top