Excel Columns: Merge or Split Data

MERGE DATA

TO

1. Select a cell in a column to the right of cells
2. To split by a space, type: =A3&" "&B3
3. To split by a line break (enter), type: =A3&CHAR(10)&B3

SPLIT DATA

TO

1. Highlight cells
2. Data Tab
3. Text to Columns
4. Delimited
5. Check space, uncheck everything else
6. Finish

VERTICAL TO HORIZONTALedit - paste special - click TRANSPOSE