Aug 11 2020 10:23 AM
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?
Aug 11 2020 10:35 AM
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?
Aug 11 2020 10:36 AM
Hello @katphelan,
It sounds like you are looking to transpose your array. Here is how to transpose data:
Aug 11 2020 10:38 AM
@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...
Aug 11 2020 10:41 AM
I'm sorry, I must be misunderstanding your question. Does transposing your entire array not yield the result you expect?
Aug 11 2020 10:43 AM
The easiest way to combine 4 columns in one is Power Query if you consider such option. Otherwise with INDEX.
Aug 11 2020 10:49 AM