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)
Data in A
=INDEX($A$1:$A$18,SEQUENCE(COUNTA(A:A)/6,6,1,1),1)
=INDEX($A$1:$A$18,SEQUENCE(COUNTA(A:A)/6,6,1,1),1)