I have a list simiar to this
1 a
b
c
d
2 a
b
c
d
etc
I need to sort the list a diffent way. Is there any way to change this
list to something like:
1 a
1 b
1 c
1 d
2 a
2 b
2 c
2 d
etc.
I thought that there was a built in function in excel to do this but I
cannot find it. Is there any way to do this either from a menu or via
programming?
Thanks Terry