Oct 16 2020 08:21 AM
I have data list of user id and password of students in a single column with the user id of the student in one row and password below the user id. Now, I want to change the data as all user id's in one row and all passwords in another row.
Oct 16 2020 08:25 AM
Enter the following formula in B2:
=INDEX(A:A,2*ROW()-2)
and in C2:
=INDEX(A:A,2*ROW()-1)
Select B2:C2, then fill or copy down.
Oct 16 2020 08:47 AM
Here is your example file with formula.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.