Consolidate data?

Guys

I am sure you all can help me...

Say I have data in a1, a3, a7, a10, a13 but I want all of the data in those cells to be consolidated and show up in e1, e2, e3, e4, e5 and so forth... so that they are consolidated without blanks, how can I do this without using the data sort and unchecking blank option. Id like to do this automatically by a function somehow.


any thoughts??