I would like to ask if it is possible to split and transpose a group of words from one cell to multiple cells in a spreadsheet. This is what it looks like in cell A1:
Zhen Rong Yu Merrill Lynch, Pierce, Fenner & Smith Incorporated
9595 WILSHIRE BLVD
BEVERLY HILLS, CA 90212
I would like to know if its possible to look like this:
A1: Zhen Rong Yu
B1: Merrill Lynch, Pierce, Fenner & Smith Incorporated
C1: 9595 WILSHIRE BLVD
D1: BEVERLY HILLS, CA 90212