Forum Discussion
Solved
Move data from cells in one column to new columns
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. Apo...
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)))
Yes!! Thank you WrapRows worked. Whew. Appreciate the quick and easy response.
Glad it worked!