| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transpose certain cells in a row while keeping other cells intact
Hello,
I was hoping someone could help me with a problem I've been stuck on for a while. I have a file like so: ID1 lName1 fName1 subj1 subj2 subj3 ID2 lName2 fName2 subj1 subj2 subj3 ID3 lName3 fName3 subj1 subj2 subj3 (etc) that I need to convert to: ID1 lName1 fName1 subj1 ID1 lName1 fName1 subj2 ID1 lName1 fName1 subj3 ID2 lName2 fName2 subj1 ID2 lName2 fName2 subj2 ID2 lName2 fName2 subj3 ID3 lName3 fName3 subj1 ID3 lName3 fName3 subj2 ID3 lName3 fName3 subj3 I can transpose easily enough, but I cant keep the first 3 fields intact and repeat them for every row. (There are over 1000 rows in the file) Does anyone have any suggestions? Thanks, Damien. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping Formulas Intact While Sorting | Excel Discussion (Misc queries) | |||
| Sorting columns while keeping row data intact | New Users to Excel | |||
| Keeping formula format intact | Excel Discussion (Misc queries) | |||
| keeping rows intact during sort | Excel Discussion (Misc queries) | |||
| How to copy cells with keeping exact formula intact | Excel Discussion (Misc queries) | |||
Threaded Mode
