title: Re-Arrange Table (summarize only certain rows)
body: <p>I have the following Table:
  <a href="https://i.stack.imgur.com/CeAs8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CeAs8.png" alt="enter image description here"></a></p>
  
  <p>Thus, whenever I have common “J No”, I would like to perform the following calculations:</p>
  
  <p>Take only the 1st value from “Set up Start” and combine it with the last two values from “Run Start” and “Run End” and delete any records in between them.</p>
  
  <p>Here is my Query code:</p>
  
  <pre><code>SELECT 
     [LineNo]
    ,[J No]
    ,[FC]
    ,[SetupStart]
    ,[UpTimeStart]
    ,[UpTimeEnd]
    ,[Setup]
    ,[UpTime]
    ,[Targ Len]
    ,[Act Len]
    ,[R Up F]
    ,[R Dn F]
    ,[Scrap]
  FROM [Initial].[dbo].[vWGetProductionInfo]
  ORDER BY SetupStart ASC, UpTimeEnd AS
  </code></pre>
  
  <p>How would I do modify this query to give me the desired output I have listed above?</p>