split text into rows and have the first clumn information repeated

C

Chia

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!
 
C

Chia

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!^_^
 
C

CLR

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
 
S

Samantha T

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
 
C

CLR

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
 
Top