lookup

[Erik]

Here is what I'd like to do:

a b c d e
1 # # #
2
3 # # #
4# #

I would like to take the information above from sheet 1 and have it automaticaly transfer over to sheet two in the specified cells as shown below:

A B C D E
1 # # #
2 # # #
3 # # #
4

Is there a formula I can use to automaticly transfer and sort the data from sheet 1 if there is data in a cell and put it into sheet 2 all nicely sorted and organized?

Thanks,

Erik