Forum Discussion
Solved
Excel I need to separate the data six by six.
Hi guys i have a data homework to do.I am trying to do that at excel. So the situation is i have got 2000 data in one row. I need to separate this data six by six. For example the data i got ...
In addition to the formula @Starrysky 1988 sent you, here is a link with other approaches, such as with VBA.
How to move every other row to column in Excel
Standard Disclaimer: These are links to non-Microsoft websites.
I know I don't know anything (Socrates)
Here is the answer for you.
=IFERROR(INDEX(INDIRECT("A2:A"&COUNTA($A:$A)),ROW(A1)*6-5+COLUMN(A1)-1),"")
=IFERROR(INDEX(INDIRECT("A2:A"&COUNTA($A:$A)),ROW(A1)*6-5+COLUMN(A1)-1),"")
- Thank you for your answer I've been dealing with this all day finally i figured it out.
