Forum Discussion

Terri372's avatar
Terri372
Copper Contributor
Oct 19, 2022
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...
excel
  • Patrick2788's avatar
    Patrick2788
    Oct 19, 2022

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

Resources