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. Thanks so much!

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.

Put this formula in Cell E1 and copy down column E. This will straighten out
the data. Then copy the Colum E data into notepad to get the straight text.

=INDIRECT(ADDRESS(INT((ROW(E1)-1)/3)+1,MOD(ROW(E1)-1,3)+1))


Only copy the data until you see all 0's in column E.


"wmphimu" wrote:

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. Thanks so much!