how do I make a list from a spreadsheet?

  • Thread starter Thread starter wmphimu
  • Start date Start date
W

wmphimu

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

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

Help to create a macro 2
Formula Question 2
Protecting user from changing previous data 5
Pivot table consolidation 1
How do I move data from one worksheet to another? 1
autoupdate data? 4
Return list from a list 3
Data Validation and drop-down list using IF, AND and what else? 8

Back
Top