Resolved: Merge data where 1 column row the same

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

select
    MasterID
    , TableDataOrder
    , max(Idea) Idea
    , max(Feasibility) Feasibility
    , max(BusinessReview) BusinessReview
    , max(Concept) Concept
    , max(DetailedDesign) DetailedDesign
    , max(TestValidation) TestValidation
    , max(ManufacturingProductIntegration) ManufacturingProductIntegration
    , max(ProductSales) ProductSales

from #Tmp

group by MasterID
    ,TableDataOrder;