Re: Difficult scenerio, move columns to a new line

katphelan 

For this concrete sample you may use

=TRANSPOSE(A1:E1)

in A4, but I guess that's not what your are looking for. How other, if not 2999 but 9 records looks like?