R
ron_dallas
I have a S/S, Column A, has Applications, Colimn B, has multi name
seperated by "," and Column C has the main person.
Is there a way for to go from :
sheet 1
A B C
CUP Ron, Tim, Jill, Tom Rick
to sheet 2
A B C
CUP Ron Rick
CUP Tim Rick
CUP Jill Rick
CUP Tom Rick
Other info:
The multi name can be from 1 to 6 people, there are 186 rows, the names
can have - and / in it, also I would like to copy the color of the
cell.
Thanks for your help!!
seperated by "," and Column C has the main person.
Is there a way for to go from :
sheet 1
A B C
CUP Ron, Tim, Jill, Tom Rick
to sheet 2
A B C
CUP Ron Rick
CUP Tim Rick
CUP Jill Rick
CUP Tom Rick
Other info:
The multi name can be from 1 to 6 people, there are 186 rows, the names
can have - and / in it, also I would like to copy the color of the
cell.
Thanks for your help!!