Help: How to separate one column into two??

[#1]

Hello All,

     I have a column in my data, named Count: basically it counts the # of pcs or skids.. so this is what it would look like

Count
1 skid
4 skid

6pcs

2 pcs

4skid

so my question is, how do i separate them into two different columns named skid count and pcs count??

[#2]

Thank you so much Mr. Roland.