| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I repeatedly transpose blocks of data?
I have blocks of data that are all in colomn A and the blocks are 27 rows in
length. I want to transpose this data into a database format. I've written the formula to do 1 line but I need to be able to copy this formula down so that it moves on 27 rows instead of the 1 that it normally does when you copy down formula. There is over 1000 blocks of data to transpose. I'm using the 2000 version. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I import formmail data to a custom excel template? | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Moving blocks of data in excel | Excel Discussion (Misc queries) | |||
| Trying to transpose linked data using Paste Special | Excel Worksheet Functions | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Threaded Mode
