Split cells within specific column

1

HI all
I am trying to split a column within my table
This column contain 6 different types of committees each committee repeated more than 100 times now I want to make each committee in its own column such that each committee still see its ID.

sql.png1920×1474 165 KB

2
  1. create a new table called dbo.committees
    committeeid
    committeename
    committeedescr
    l
  2. add comitteeid column to request table
  3. create an update statement to update this new column committeeid by joining to new committe table
  4. make committeeid column not null
  5. create fk relationship from request table to new committee table