Split information from 1 columns to 4 columns in EXCEL 2003 : Hey guys i have a excel list file 2003 version with information about employer..

I recive the list every year with the information in the same column [here][1] 

My problem is that i do the previous expample copying and pasting and is very tiring because i have more than 100 names with his respective months.

I let the pasting like this.
[here][2]

im trying to do a dinamic table but i dont know how separate the information in 4 columns because all is in the same column and, how  can i convert the "sector name" in a column?. Any suggestion or idea?




  [1]: https://i.stack.imgur.com/emwmx.png
  [2]: https://i.stack.imgur.com/4bQUK.png