I have an excel sheet that contains names (1st row), job titles (2nd row), company/institution (3rd row), and addresses(4th row) in one big column.
I am trying to separate them into four different columns.
closed as unclear what you're asking by Scott, fixer1234, DavidPostill, bwDraco, Art Gertner Mar 18 '15 at 12:53
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.
Looks like what you want is Copy >> Special Paste >> Transpose. You seem to want to switch rows to columns.
When I read your question, I understood it to mean that you have
and you want
Assuming your data are in Column A, starting in cell A1, set up
Then, for the example data I provided for A1, you will get the following results: