How to separate from 1 column to multiple column MS SQL SERVER : i have table need to separate the data to multiple column. 

 "Site Name","PJ.143 USJ 1| 2A (MP)","PMAC ID:","0067","Channel No:","01"

How to separate from 1 column to multiple column MS SQL SERVER

Thanks.