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. 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!
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)))
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!
