title: Best way to condense several columns of the same data?
body: <p>The question doesn't do the problem justice, so let me try and explain. I'm reorganizing a database which has (amongst other things) 20 fields with tools to be used for a job. Not every job needs 20 tools, some require 1 or 2 or 3.
  I was thinking I could grab the info from the 20 existing fields and plop them into a table called tbl_Tools with a single tools field and a key. Then, in the main table remove the 20 fields and add one single field with a reference to the key of tbl_Tools and condense the info of the 20 fields into a single string variable where each tool is separated by a comma (this only has to be done because the location of each tool is important to save). Figure below has a basic explanation.</p>
  
  <p>It this optimal or is there a better way of doing this I'm not figuring out? I'd love to hear your feedback.</p>
  
  <p>Thanks in advance, Rafael.
  (Also not sure which tags to use for this)</p>
  
  <p><a href="https://i.stack.imgur.com/vHw5q.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vHw5q.png" alt="enter image description here"></a></p>