title: Split column data into multiple rows
body: <p>I have data currently in my table like below under currently section. I need the selected column data which is comma delimited to be converted into the format marked in green  (Read and write of a category together) 
  <a href="https://i.stack.imgur.com/l7BTX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/l7BTX.png" alt="enter image description here"></a></p>
  
  <p>Any ways to do it in SQL Server?</p>
  
  <p>Please do look at the proposal data carefully....
  Maybe I wasn't clear before: this isn't merely the splitting that is the issue but to group all reads and writes of a category together(sometimes they are just merely reads/writes), it's not merely putting comma separated values in multiple rows.</p>
  
  <pre><code>--    script:
      use master 
      Create table prodLines(id int  , prodlines varchar(1000))
      --drop table prodLines
      insert into prodLines values(1, 'Automotive Coatings (Read), Automotive Coatings (Write), Industrial Coatings (Read), S.P.S. (Read), Shared PL''s (Read)')
      insert into prodLines values(2, 'Automotive Coatings (Read), Automotive Coatings (Write), Industrial Coatings (Read), S.P.S. (Read), Shared PL''s (Read)')
  
      select * from prodLines
  </code></pre>