Very simple but would save me a hell of a lot of copy and pasting.

Ive got a spreadsheet that has a list of names in each column. i.e. Col A
has Rob in rows 1-4, B has Cesc in 1-4, C has Robin in 1-4, D has Gael in 1-4
etc.

I need to see these in a single column. So, row E will become Rob in E1 -
E4, Cesc in E5-E8, Robin in E9-E12 and Gael in E13 - E16

Many thanks to any genuis that can help me..
Rob
--
Rob Gaffney