are you sorted yet? if not send me pm with link to file
actually
put this in cell
c1 =INDIRECT("r"&(3*ROW())-2&"c1",FALSE)
d1 =INDIRECT("r"&(3*ROW())-1&"c1",FALSE)
e1 =INDIRECT("r"&3*ROW()&"c1",FALSE)
this is for data without headers and pull formula down
again, will only work without...