Forum Discussion
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, ...
In C2:
=LET(list, A1:A9, n, COUNTA(list), names, CHOOSEROWS(list, SEQUENCE(n/3, ,1, 3)), first, TEXTBEFORE(names, " "), last, TEXTAFTER(names, " "), phone, CHOOSEROWS(list, SEQUENCE(n/3, , 2, 3)), email, CHOOSEROWS(list, SEQUENCE(n/3, , 3, 3)), HSTACK(first, last, phone, email))