Excel VBA Text To Column
- by Pat
This is what I currently have:
H101 John Doe Jane Doe Jack Doe
H102 John Smith Jane Smith Katie Smith Jack Smith
And here is what I want:
H101 John Doe
H101 Jane Doe
H101 Jack Doe
H102 John Smith
H102 Jane Smith
H102 Katie Smith
H102 Jack Smith
Obviously I want to do this on a bigger scale. The number of…