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)
If you are office365 users, you may use dynamic array formula as below.
=Makearray(Ceiling(Quotient(Counta($A2:$A3000),6),1),6,Lambda(r,c,Index($A2:$A3000,r*6-5+c-1)))