title: Create Multiple row from single row
body: <p>I have data from 1 table with single row data<br>
  link : <a href="https://www.dropbox.com/s/86j2o9jo9v8vqip/stack1.PNG?dl=0" rel="nofollow noreferrer">https://www.dropbox.com/s/86j2o9jo9v8vqip/stack1.PNG?dl=0</a></p>
  
  <pre><code>Function    dateMarine      NumberMarine    dateBOC         NumberBOC   Status
  ------------------------------------------------------------------------------
  Shipping    2000/01/01      10              2007/01/01      11          Paid         
  </code></pre>
  
  <p>And I want to create multiple row from single row data 1 shipmentNumber , like this</p>
  
  <pre><code>Function    No.Doc  date        status 
  --------------------------------------
  Shipping   10       2000/01/01  Paid
  Shipping   11       2007/01/01  Paid  
  </code></pre>
  
  <p>How to create query for this case, I have some reference like this:</p>
  
  <pre><code>SELECT [Date]
        , API
        , LEFT(col,CHARINDEX('_',col)-1)'Latency'
        , RIGHT(col,CHARINDEX('_',REVERSE(col))-1)'Aggregation'
        , Value
  FROM
  (
    SELECT [Date],API,col,value
    FROM Table1
    CROSS APPLY
    (
      VALUES ('Latency1_Avg', [Latency1_Avg]),('Latency1_Min', [Latency1_Min]),('Latency1_Max', [Latency1_Max]),('Latency2_Avg', [Latency2_Avg]),('Latency2_Min', [Latency2_Min]),('Latency2_Max', [Latency2_Max])
    ) C (COL, VALUE)
  ) SRC
  </code></pre>
  
  <p>But i think my case is different</p>
  
  <p>sorry i use the link to show picture of my case, because i cant import pic in my stackoverflow account </p>
  
  <p>Thankyou for youre helping me</p>