| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
split text into rows and have the first clumn information repeated
ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will do just that........ Vaya con Dios, Chuck, CABGx3 "Chia" wrote: 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
split text into rows and have the first clumn information repe
Thanks, Chuck. ASAP is a very powerful tool. It would have saved me a lot of
time if I have started to use it in the first place. Thank you so much!^_^ "CLR" wrote: ASAP Utilities, a free add-in available at www.asap-utilities.com has a feature that will do just that........ Vaya con Dios, Chuck, CABGx3 "Chia" wrote: 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
split text into rows and have the first clumn information repe
You're quite welcome, and thanks for the feedback.
And you're right, it's very handy..........I use it all the time. Vaya con Dios, Chuck, CABGx3 "Chia" wrote: Thanks, Chuck. ASAP is a very powerful tool. It would have saved me a lot of time if I have started to use it in the first place. Thank you so much!^_^ "CLR" wrote: ASAP Utilities, a free add-in available at www.asap-utilities.com has a feature that will do just that........ Vaya con Dios, Chuck, CABGx3 "Chia" wrote: 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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
split text into rows and have the first clumn information repe
Hello,
I am a similar problem and I downloaded the ASAP utilities add-in but can not find the feature to split the rows - can you guide me the right direction? Thanks Sam -- "CLR" wrote: ASAP Utilities, a free add-in available at www.asap-utilities.com has a feature that will do just that........ Vaya con Dios, Chuck, CABGx3 "Chia" wrote: 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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
split text into rows and have the first clumn information repe
Hi Samantha...........
Sorry, didn't mean to imply that ASAP Utilities had a one-button feature that solved the problem completely. Solving this problem is a multi-step procedure and ASAP Utilities has features that make some of those steps easier.....such as the filling down values into spaces, or deleting the invisible characters, etc. Vaya con Dios, Chuck, CABGx3 "Samantha T" wrote: Hello, I am a similar problem and I downloaded the ASAP utilities add-in but can not find the feature to split the rows - can you guide me the right direction? Thanks Sam -- "CLR" wrote: ASAP Utilities, a free add-in available at www.asap-utilities.com has a feature that will do just that........ Vaya con Dios, Chuck, CABGx3 "Chia" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
