Difficult scenerio, move columns to a new line

[katphelan]

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?

[#2]

@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?

[#3]

Hello @katphelan,

It sounds like you are looking to transpose your array. Here is how to transpose data:

1. Highlight A1:E1
2. Copy (Ctrl + C)
3. Select an empty cell that has four additional empty cells below it
4. Paste (Ctrl + P) then press Ctrl then press T

[#4]

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

[#5]

@katphelan,

I'm sorry, I must be misunderstanding your question. Does transposing your entire array not yield the result you expect?

[#6]

@katphelan 

The easiest way to combine 4 columns in one is Power Query if you consider such option. Otherwise with INDEX.

[#7]

@katphelan 

Like this

with

=INDEX(A:D,INT((ROW()-1)/4)+1,MOD(ROW()-1,4)+1)