split text into rows and have the first clumn information repeated

[Guest]

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!

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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