| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Slightly long winded transposition
4073 Leary Rob U5 U51EN/SMT EN
4073Leary Rob U5 U5CCH1 CH AEW 4073 Leary Rob U5 U5AAR1 AR LC 4073 Leary Rob U5 U5BHI1 HI RF 4073 Leary Rob U5 U5EPE1 PE SMX 4073 Leary Rob U5 U5FIT3 IT AH 4073 Leary Rob U5 U5DFR2 FR CEL 4073 Leary Rob U5 U5MA/PJW MA PJW |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Slightly long winded transposition
Sorry my pc went a bit loopy and posted before I had finished writing.
I need a routine that systematically takes the last three columns (starting at the second row) and moves the data up to the first row, basically I will get 25 columns and 1 row when I finish. "Wendy" wrote: 4073 Leary Rob U5 U51EN/SMT EN 4073 Leary Rob U5 U5CCH1 CH AEW 4073 Leary Rob U5 U5AAR1 AR LC 4073 Leary Rob U5 U5BHI1 HI RF 4073 Leary Rob U5 U5EPE1 PE SMX 4073 Leary Rob U5 U5FIT3 IT AH 4073 Leary Rob U5 U5DFR2 FR CEL 4073 Leary Rob U5 U5MA/PJW MA PJW Thanks for help Wendy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex Transposition | Excel Discussion (Misc queries) | |||
| Transposition impossibility? | Excel Discussion (Misc queries) | |||
| Transposition | Excel Worksheet Functions | |||
| Transposition of data | Excel Programming | |||
| Long-winded code | Excel Programming | |||
Hybrid Mode
