SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Table_1(
   StockTransferId      INTEGER  NOT NULL
  ,CompanyMasterId      INTEGER  NOT NULL
  ,BranchGodownMasterId INTEGER  NOT NULL
  ,DocumentNo           INTEGER  NOT NULL
  ,DocumentDate         DATE  NOT NULL
  ,Itg_Tiles_SizeInMM   VARCHAR(12) NOT NULL
  ,Itg_Tiles_Design     VARCHAR(12) NOT NULL
  ,Itg_Tiles_Grade      VARCHAR(4)
  ,Quantity             INTEGER  NOT NULL
  ,ProductionQty        NUMERIC(5,2) NOT NULL
);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','300 X 600','BERGAMO GRIS',NULL,1250,0.00);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','300 X 600','CANCUN BEIGE','COM',8,5.06);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','300 X 600','CANCUN BEIGE','GOLD',150,94.94);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','396 X 396','BARSILONA',NULL,5650,83.37);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','396 X 396','BARSILONA','COM',6,0.09);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','396 X 396','BARSILONA','GOLD',1116,16.47);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','396 X 396','BARSILONA','UTL',5,0.07);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','396 X 396','DRAGO',NULL,50,83.33);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','396 X 396','DRAGO','GOLD',10,16.67);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BEIGE',NULL,7335,90.66);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BEIGE','COM',27,0.33);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BEIGE','INTL',721,8.91);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BEIGE','OTC',8,0.10);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BLANCO',NULL,45990,96.33);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BLANCO','INTL',1533,3.21);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BLANCO','OTC',218,0.46);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BRANCA','COM',280,8.26);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BRANCA','INTL',3005,88.67);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BRANCA','OTC',104,3.07);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BROWN',NULL,7720,90.94);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BROWN','COM',35,0.41);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BROWN','INTL',734,8.65);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','CUPRA',NULL,45,91.84);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','CUPRA','INTL',4,8.16);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','GRIGIO',NULL,8970,90.91);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','GRIGIO','COM',56,0.57);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','GRIGIO','INTL',841,8.52);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','ROSSO',NULL,43072,91.00);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','ROSSO','INTL',3974,8.40);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','ROSSO','OTC',286,0.60);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','600X600X10MM','CALDI BIANCO',NULL,100,80.65);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','600X600X10MM','CALDI BIANCO','COM',24,19.35);

32 rows affected

DECLARE @prd_cols AS NVARCHAR(MAX)
     ,  @qty_cols AS NVARCHAR(MAX)
     ,  @query  AS NVARCHAR(MAX)

select distinct
      case when Itg_Tiles_Grade IS NULL then 1 else 2 end as rn
    , case when Itg_Tiles_Grade IS NULL
           then 'SUM( CASE WHEN Itg_Tiles_Grade IS NULL THEN ProductionQty END )  AS Production_blank' 
           else 'SUM( CASE WHEN Itg_Tiles_Grade = ''' 
                + Itg_Tiles_Grade
                + ''' THEN ProductionQty END ) AS Production_'
                + Itg_Tiles_Grade
      end prd_cols
    , case when Itg_Tiles_Grade IS NULL
           then 'SUM( CASE WHEN Itg_Tiles_Grade IS NULL THEN Quantity END )  AS Quantityblank' 
           else 'SUM( CASE WHEN Itg_Tiles_Grade = ''' 
                + Itg_Tiles_Grade
                + ''' THEN Quantity END ) AS Quantity_'
                + Itg_Tiles_Grade
      end qty_cols
into #cols_temp
from table_1

SET @prd_cols = (SELECT ', ' + prd_cols
                  FROM #cols_temp
                  order by rn, prd_cols
                  FOR XML PATH(''), TYPE
                   ).value('.', 'NVARCHAR(MAX)') 
        
SET @qty_cols = (SELECT ', ' + qty_cols
                  FROM #cols_temp
                  order by rn, prd_cols
                  FOR XML PATH(''), TYPE
                   ).value('.', 'NVARCHAR(MAX)')

set @query = 'SELECT
    StockTransferId
  , CompanyMasterId
  , BranchGodownMasterId
  , MAX( DocumentDate ) as DocumentDate
  , Itg_Tiles_SizeInMM
  , Itg_Tiles_Design
  '
+ @prd_cols
+ ' 
  '
+ @qty_cols        
+ ' 
 FROM table_1
 GROUP BY
    StockTransferId
  , CompanyMasterId
  , BranchGodownMasterId
  , Itg_Tiles_SizeInMM
  , Itg_Tiles_Design'
  
--select @query

execute(@query)

StockTransferId	CompanyMasterId	BranchGodownMasterId	DocumentDate	Itg_Tiles_SizeInMM	Itg_Tiles_Design	Production_blank	Production_COM	Production_GOLD	Production_INTL	Production_OTC	Production_UTL	Quantityblank	Quantity_COM	Quantity_GOLD	Quantity_INTL	Quantity_OTC	Quantity_UTL
20294	2	3	21/12/2018 00:00:00	300 X 600	BERGAMO GRIS	0.00	null	null	null	null	null	1250	null	null	null	null	null
20294	2	3	21/12/2018 00:00:00	300 X 600	CANCUN BEIGE	null	5.06	94.94	null	null	null	null	8	150	null	null	null
20294	2	3	21/12/2018 00:00:00	396 X 396	BARSILONA	83.37	0.09	16.47	null	null	0.07	5650	6	1116	null	null	5
20294	2	3	21/12/2018 00:00:00	396 X 396	DRAGO	83.33	null	16.67	null	null	null	50	null	10	null	null	null
20296	1	4	22/12/2018 00:00:00	300X300X10MM	BEIGE	90.66	0.33	null	8.91	0.10	null	7335	27	null	721	8	null
20296	1	4	22/12/2018 00:00:00	300X300X10MM	BLANCO	96.33	null	null	3.21	0.46	null	45990	null	null	1533	218	null
20296	1	4	22/12/2018 00:00:00	300X300X10MM	BRANCA	null	8.26	null	88.67	3.07	null	null	280	null	3005	104	null
20296	1	4	22/12/2018 00:00:00	300X300X10MM	BROWN	90.94	0.41	null	8.65	null	null	7720	35	null	734	null	null
20296	1	4	22/12/2018 00:00:00	300X300X10MM	CUPRA	91.84	null	null	8.16	null	null	45	null	null	4	null	null
20296	1	4	22/12/2018 00:00:00	300X300X10MM	GRIGIO	90.91	0.57	null	8.52	null	null	8970	56	null	841	null	null
20296	1	4	22/12/2018 00:00:00	300X300X10MM	ROSSO	91.00	null	null	8.40	0.60	null	43072	null	null	3974	286	null
20296	1	4	22/12/2018 00:00:00	600X600X10MM	CALDI BIANCO	80.65	19.35	null	null	null	null	100	24	null	null	null	null

Warning: Null value is eliminated by an aggregate or other SET operation.