Mar 26 2022 05:34 PM
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
the data i want to get
Thank you.
Mar 26 2022 07:58 PM
Mar 27 2022 12:28 AM
SolutionIn 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)
Mar 27 2022 01:50 AM
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)))
Mar 27 2022 02:10 AM
An alternative could be to manually enter formulas =A2, =A3, =A4, =A5, =A6, =A7 in cells B2, C3, D4, E5, F6 and G7.
Then select range B2:G7 and fill down to row 28 in the attached example.
Then copy range B2:G28 and paste only values.
Now select only blanks with ctrl+G and delete blanks with right mouseclick and delete cells.
Mar 27 2022 02:30 AM
Hope WRAPROWS function (microsoft.com) will be available soon for everyone, not only insiders.
Mar 27 2022 02:40 AM
Mar 27 2022 10:42 AM
Mar 27 2022 12:28 AM
SolutionIn 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)