Copying across multiple files
 

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

Copying across multiple files
 

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

Copying across multiple files
 

Thank you. I did not do my job well enough. I also found an answer
he http://www.mvps.org/dmcritchie/excel/fillempt.htm. Just in case
some one else runs into the same problem. Thanks for all the help

Copying across multiple files
 

Thank you. I did not do my job well enough. I also found an answer
he http://www.mvps.org/dmcritchie/excel/fillempt.htm. Just in case
some one else runs into the same problem. Thanks for all the help