Difficult scenerio, move columns to a new line

Question

I have to move items that are in a line, across columns, to be moved to their own line. I have 3000 records to do this with.

Basically lets say you have a basket (column A1) in that basket is cheese, sausage, crackers and wine, (columns b1,c1,d1,e1)

I need them to be

a1 b1 c1 d1 e1

screen shot for reference

Anyone know if I can do this?

sergeibaklan · Answer

katphelan&nbsp;
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?

preagan · Answer

Hello&nbsp;katphelan,&nbsp;It sounds like you are looking to transpose your array. Here is how to transpose data:Highlight A1:E1Copy (Ctrl + C)Select an empty cell that has four additional empty cells below itPaste (Ctrl + P) then press Ctrl then press T&nbsp;

katphelan · Answer

PReagan&nbsp;but how do i do this for 3000 lines of data....do i have to put in empty lines first?&nbsp; Its easy for one line with 4 columns but when i have 3000 lines of 4 columns...