title: Google Sheets - Create SKU that automates content into separate columns
body: <p>I would like to create a column (SKU) in my Google sheets CSV that when data is manually input in each cell, it will automatically fill out the content in 3 other columns (Title, Colour, Size).</p>
  <p>I have created an example CSV with the necessary columns highlighted.</p>
  <p><code>Column B - Product title</code> <code>Column I - Colour</code> <code>Column K - Size</code> <code>Column N - SKU</code></p>
  <p><strong>Example SKU Inputs (Manually entered into column N)</strong></p>
  <p><code>L24-1-000</code> <code>C-2-150</code></p>
  <p><strong>Breakdown of values assigned to each section:</strong></p>
  <p><code>L24 = Lightweight trainers</code>  <code>S24 = Sandals</code></p>
  <p><code>1 = Blue</code> <code>2 = Red</code></p>
  <p><code>000 = 0</code>
  <code>150 = 1.5</code></p>
  <p><strong>Output (Automated in columns B, I and K)</strong></p>
  <p><code>'Lightweight trainers', 'Blue', '0'</code></p>
  <p><code>'Sandals', 'Red', '1.5'</code></p>
  <p><strong>Link to CSV</strong></p>
  <p><a href="https://docs.google.com/spreadsheets/d/1E6NypRcWk4kR7WGsyEzt7Uuja8dU7SaszT9lvJPpHcg/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1E6NypRcWk4kR7WGsyEzt7Uuja8dU7SaszT9lvJPpHcg/edit?usp=sharing</a></p>