title: Merge data where 1 column row the same
body: <p>Current data:</p>
  <pre><code>IF OBJECT_ID(N'tempdb..#Tmp') IS NOT NULL
  BEGIN
  DROP TABLE #Tmp
  END
  create table #Tmp (MasterID int,TableDataOrder int,Idea varchar(50),Feasibility varchar(50),BusinessReview varchar(50)
                      ,Concept varchar(50),DetailedDesign varchar(50),TestValidation varchar(50),ManufacturingProductIntegration varchar(50)
                      ,ProductSales varchar(50))
  insert into #Tmp
  select 26,1,NULL,'02',NULL,NULL,NULL,NULL,NULL,NULL
  insert into #Tmp
  select 26,1,NULL,NULL,NULL,'04',NULL,NULL,NULL,NULL
  insert into #Tmp
  select 26,1,NULL,NULL,NULL,NULL,'05',NULL,NULL,NULL
  insert into #Tmp
  select 26,2,NULL,NULL,NULL,NULL,'05',NULL,NULL,NULL
  insert into #Tmp
  select 26,3,NULL,NULL,NULL,NULL,'05',NULL,NULL,NULL
  insert into #Tmp
  select 26,4,NULL,NULL,NULL,NULL,'05',NULL,NULL,NULL
  
  select * from  #Tmp
  </code></pre>
  <p>Current Result:</p>
  <p><a href="https://i.stack.imgur.com/eFQ2S.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eFQ2S.png" alt="CurrentResult" /></a></p>
  <p>Expected Result:</p>
  <p><a href="https://i.stack.imgur.com/A96fl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/A96fl.png" alt="ExpectedResult" /></a></p>
  <p>How to merge the data where TableDataOrder is the same?</p>