One way

In E1:
=OFFSET($A$1,MOD(ROWS($1:1)-1,4),INT((ROWS($1:1)-1)/4))
Copy down to E16
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gaffnr" wrote:
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