Not sure how to even approach this. How do I complete the following which has come from a form:
ColA (UniqID) ColB
41447.9162847222 Name1, Name2, Name3, Name4
41447.9158912037 Name2, Name6, Name9
I would like to end up with:
ColA B
41447.9162847222 Name1
41447.9162847222 Name2
41447.9162847222 Name3
41447.9162847222 Name4
41447.9158912037 Name2
41447.9158912037 Name6
41447.9158912037 Name9
I can't use VLOOKUP or MATCH as Names may be duplicated in other records but ColA code will always be unique.
T
See Question&Answers more detail:os