Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
i need to insert data in a large spreadsheet
i have data in one column listed on every row i need to move it to a new
column every 13 row down ex. row 1)dog row 1) dog row 2)cat row 13)cat row 3)rat row 26) rat |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
i need to insert data in a large spreadsheet
Assuming you data is in column A, put this in a helper column:
=IF(MOD(ROW(A1)+12,13)=0,INDIRECT("A"&INT((ROW(A1) +12)/13)),"") and then copy down as required. Note that with an increment of 13 rows, you will get the values occurring on rows 1, 14, 27 etc, not 1, 13, 26. Hope this helps. Pete "calvin" wrote in message ... i have data in one column listed on every row i need to move it to a new column every 13 row down ex. row 1)dog row 1) dog row 2)cat row 13)cat row 3)rat row 26) rat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I insert data into my spreadsheet without the page breaks. | Excel Worksheet Functions | |||
Insert large excel object into word | Excel Discussion (Misc queries) | |||
Using data form in large mailing list spreadsheet | Excel Discussion (Misc queries) | |||
How do I get to the last line of a large spreadsheet to add data | Excel Worksheet Functions | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |