Skipping rows

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I'm trying to copy the contents from one sheet to another. My objective is
take data that is in a row and move it into a column on another sheet.
EX. move c2 in sheet a to k2 in new sheet. Repeat this but skip from c2 to
c6 and place it in k3 etc.
 
Rob,

This assumes the data your copying is on sheet 1. Put the formula in k2 of
another sheet and drag down

=INDEX(Sheet1!C:C,(ROW(A1)-1)*4+2)

Mike
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top