Forum Discussion

Copper Contributor

Nov 07, 2024

Data organized in Columns instead of Rows - Excel

Hi, In excel, I have a long list of data that I want to organized in 4 columns (First Name, Last Name, Phone and Email), the thing is that the data I have is in one column, so like in the image, ...

excel

djclements

Bronze Contributor

Nov 08, 2024

Another possible variation for modern Excel:

=LET(
    wrapArray, WRAPROWS(A1:A12,3),
    fullNames, TAKE(wrapArray,,1),
    HSTACK(
        TEXTBEFORE(fullNames," ",,,1),
        TEXTAFTER(fullNames," ",,,1),
        DROP(wrapArray,,1)
    )
)