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!