Separating column into multiple columns using row value

Hi,

I want to separate a column into multiple columns by giving a script a string to split the column by. I have over 5000 rows that I want to separate so I would like to do this via VBA (or some kind of code). The data is set out like this:

enemyID
0
0.3749957859
0.4986839990
etc....
enemyID
1
0.848598690
0.278965799
etc....

I want to be able to separate the column at every instance of "enemyID" (or another string) that appears in the column. It would like it to look like this:

enemyID	enemyID
0	1
0.3749957859	0.848598690
0.4986839990	0.278965799
etc....	etc....

I'm unfamiliar with VBA and this is beyond my Excel knowledge. If anyone knows if this question has been answered or how to solve this, I'd appreciate any help. Please let me know if I need to provide more detail.

Thank you.

Hi ,

pls view the attachment , some vba code ,will finger this out .



Good Luck !

Output in sheet 3

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Thank you for all your help everybody, your code has been extremely helpful and educational. I really appreciate the time you've given to me.