| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Putting column values in multiple rows
Hi, I am using SPSS data and would like to rearrange it in Excel.
The original file contains rows with 64 columns, one row representing 1 record: Example: Code mis1 ebus1 cont1 mis2 ebus2 cont2 626 5 6 1 .... (9 values) ... 2 8 7 .... Now I would like to have, by 9 column values one row, resulting in 7 rows by record: Example: Code mis ebus cont 626 5 6 1 ... 2 8 7 ... 1 1 4 ... 7 7 1 ... 6 6 1 ... 7 7 5 ... 7 7 1 ... Any help would be appreciated ! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| retrieving multiple corresponding values with variable rows/column | Excel Worksheet Functions | |||
| How to retrieve multiple values in multiple rows with one criteria | Excel Discussion (Misc queries) | |||
| Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
| Problem when trying to convert one column with multiple rows to one row with multiple column | Excel Programming | |||
Threaded Mode
