Linking a repeating pattern of non-adjacent cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to transpose an Excel worksheet where every fourth cell is selected
and placed into a single column of another workbook. Can I write a formula
to do this so I don't have to manually copy each cell I need?
 
If your original data were in col. A, you could put this
in A1 of a new wb:

=OFFSET([Book8]Sheet1!$A$1,ROW()*4-4,)

and drag down. It'll pull in the values in row 1, row 5,
row 9, and so on.

HTH
Jason
Atlanta, GA
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copying a column of single cells into a column of merged cells 1
non-adjacent select display 1
fill in date into adjacent cell automatically 2
CTRL+Left-Click for Copying Non-Adjacent Cells Not Working 2
transpose array of non-adjacent cells 3
Auto fill adjacent cells 3
Adding current dates to adjacent cells automatically. 2

Back
Top