This seems like it should be simple, but I have tried and tried multiple formulas and can't come up with a solution.
This is how my data is arranged, starting from Row 2. Row 1 has headers.
First word is in Column A, second set of data to the right is in column B.
Box XY
Box ZZ
Box AA
Box AB
Cup AD
Bowl ZA
Plate ZL
Plate QR
Plate KQ
I want the data to look like this in another column:
Box
XY
ZZ
AA
AB
Cup
AD
Bowl
ZA
Plate
ZL
QR
KQ
Bookmarks