Thread: split text into rows and have the first clumn information repeated
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chia Chia is offline
external usenet poster
  
Posts: 5
Default 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!
Reply With QuoteReply With Quote