Move data from cells in one column to new columns

[Terri372]

I want to take a list of excel data that has Name, Company, Title of 300 different people in one Column, and transpose (?) it so that Name is in column A, Company in Column B, Title in Column C.  Apologies but I can't find out how to do that anywhere or maybe I don't have the right language to articulate what I'm trying to do. Seems like it should be an easy move - advice? thanks!  

[#2 · Accepted solution]

@Terri372 

If you have 365, it's straightforward:

=WRAPROWS(A1:A9,3)

Without WRAPROWS, you could do:

=LET(names,A1:A9,INDEX(names,SEQUENCE(ROWS(names)/3,3)))

[#3]

@Terri372 

An alternative could be Power Query.

[#4]

Yes!! Thank you WrapRows worked. Whew. Appreciate the quick and easy response.

[#5]

Glad it worked!