You could you use formulation, then copy-paste values:

1 a =a1
b =a1
c =a1
d =a1
2 a =a4
b =a4
c =a4
d =a4





"Terry K" wrote:

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