In column A, would have the names of the individuals( the number of individuals is variable), the columns represented by a "-"
the other columns have numbers or marks. ( The number of columns representing the marks is variable)
would like a macro that can arrange the marks right next to the individual names
input is :
mark-21-34-45-56-77
Hilary-2-34-45
shawn-89-12-34-45-56-67-77
smark-34-34
output would be:
mark - 21
mark - 34
mark - 45
mark - 56
mark - 77
Hilary - 2
Hilary - 34
Hilary - 45
shawn - 89
shawn - 12
shawn - 34
shawn - 45
shawn - 56
shawn - 67
shawn - 77
smark - 34
smark - 34
please help
Bookmarks