Skipping rows

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.
 
M

Mike H

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.
 

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

IF conditional to copy column from one spreadsheet to another 3
COUNT rows on external sheet if between date range 3
Dependent drop down dynamic range formula, off sheet. 7
***Help on writing a vba code 12
Excel Vertical to horizontal repeat after 16 rows 3
Help IfBlank use data from next cell 9
Excel formula help please 3
transpose data 3

Top