Convert a data in Rows to columns

[rahmanpragati]

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. 

[#2]

@rahmanpragati 

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.

[#3]

@rahmanpragati 

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.