I have an excel sheet (mac, Excel 2011) that contains names (1st row), job titles (2nd row), and company/institution (3rd row) in one big column. I am trying to separate them into three different columns. I've tried all the macros i could find. Please help.
So instead of reading like this, as it does now:
Joe Joe SomeJob MyCompany
It would read
JoeJoe | SomeJob | MyCompany