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