View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf MyVeryOwnSelf is offline
external usenet poster
 
Posts: 213
Default how do I make a list from a spreadsheet?

Hi! I am looking to make a list (in either a Word document or new
Excel sheet) from data in an existing spreadsheet. I need to include
all the data, but ordered A1, B1. C1, A2, B2, C2, etc.
It doesn't have to be anything fancy - just a sorted out list
straight down would be perfect.


Here’s one way.

Start with the original data in Sheet1.

Start a new sheet and put this in cell A1:
=OFFSET(Sheet1!$A$1,INT((ROW()-1)/3),MOD(ROW()-1,3))

Extend A1 down for as many rows as needed.