split text into rows and have the first clumn information repeated

  • Thread starter Thread starter Guest
  • Start date Start date
G

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