| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
split text into rows and have the first clumn information repeated
Hi,
I have data like the followings: A B C 1 DrugA Preclinical I 5/3/03 Preclinical II 5/5/05 PC III 5/5/06 2 DrugB Preclinical III 4/3/03 Phase II 9/5/05 PC III 1/5/06 The information under B is seperated by square(alt+0101). How can I get the list like A B C 1 DrugA Preclinical I 5/3/03 2 DrugA Preclinical II 5/5/05 3 DrugA PC III 5/5/06 4 DrugB Preclinical III 4/3/03 5 DrugB Phase II 9/5/05 6 DrugB PC III 1/5/06 Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| repeated rows to single rows with many columns | Excel Discussion (Misc queries) | |||
| How do I split a column of information into two? | New Users to Excel | |||
| split text into rows and have the first clumn information repeated | Excel Discussion (Misc queries) | |||
| Split text , uniformly paste in rows and columns. | Excel Programming | |||
| Printing text in a repeated cell/row that is longer than repeated | Excel Discussion (Misc queries) | |||
Threaded Mode
