Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text to Column and Transpose?
My Excel skills are fairly minimal and i need help with a very time
consuming project. One of our program managers has asked me to take the following data: A1 B1 SOW WBS 3.10.8.0; 3.14.0; 3.12.3.0; 3.12.5.0; 1.1 3.12.7.0; 3.12.8.0; 3.12.9.0 And change the data to: A B 3.10.8.0 1.1 3.14.0 1.1 3.12.3.0 1.1 3.12.5.0 1.1 3.12.7.0 1.1 3.12.8.0 1.1 3.12.9.0 1.1 I would need to take the SOW reference and have it in its own cell and have it relate to the WBS from B1 still. i can do this with text to columns and transpose but i have to do it on 1000+ cells and it will be very time consuming. If anyone has any ideas i would be very grateful! Thanks, KO |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose Column to Row | Excel Worksheet Functions | |||
column 2 to transpose using column 1 as reference | Excel Discussion (Misc queries) | |||
Transpose a text string while copying adjacent column data to new | Excel Worksheet Functions | |||
transpose column to a row? | Excel Discussion (Misc queries) | |||
macro to transpose cells in Column B based on unique values in Column A | Excel Programming |