SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE TEMP(TID varchar(100),
                  FName varchar(100),
                  LName varchar(100),
                  LDate date);
INSERT INTO TEMP VALUES ('878A','user1','user2','20190101');
INSERT INTO TEMP VALUES ('878A','user1','user2','20190301');
INSERT INTO TEMP VALUES ('878A','user1','user3','20190401');
3 rows affected

DECLARE @SQL nvarchar(MAX);

SET @SQL = N'SELECT V.COLUMNS,' + NCHAR(13) + NCHAR(10) +
           STUFF((SELECT N',' + NCHAR(13) + NCHAR(10) +
                         N'       MAX(CASE T.LDATE WHEN ' + QUOTENAME(CONVERT(varchar(8),T.LDATE,112),'''') + N' THEN CASE V.COLUMNS ' +
                         STUFF((SELECT NCHAR(13) + NCHAR(10) +
                                       N'                                                            WHEN N' + QUOTENAME(C.COLUMN_NAME,'''') + N' THEN CONVERT(varchar(100),' + QUOTENAME(C.COLUMN_NAME) + N')'
                                FROM INFORMATION_SCHEMA.COLUMNS C
                                WHERE TABLE_NAME = N'TEMP'
                                  AND COLUMN_NAME != N'LDATE'
                                ORDER BY ORDINAL_POSITION ASC
                                FOR XML PATH(N''),TYPE).value('.','nvarchar(MAX)'),1,62,N'') + NCHAR(13) + NCHAR(10) +
                         N'                                             END' + NCHAR(13) + NCHAR(10) +
                         N'           END) AS ' + QUOTENAME(CONVERT(varchar(10),LDATE,103))
                  FROM TEMP T
                  GROUP BY LDATE
                  ORDER BY LDATE
                  FOR XML PATH(N''),TYPE).value('.','nvarchar(MAX)'),1,3,N'') + NCHAR(13) + NCHAR(10) +
           N'FROM TEMP T' + NCHAR(13) + NCHAR(10) +
           N'     CROSS APPLY (VALUES' + STUFF((SELECT N',(N' + QUOTENAME(COLUMN_NAME,'''') + N')'
                                                FROM INFORMATION_SCHEMA.COLUMNS
                                                WHERE TABLE_NAME = N'TEMP'
                                                  AND COLUMN_NAME != N'LDATE'
                                                ORDER BY ORDINAL_POSITION ASC
                                                FOR XML PATH(N''),TYPE).value('.','nvarchar(MAX)'),1,1,N'') + N') V(COLUMNS)' + NCHAR(13) + NCHAR(10) +
           N'GROUP BY V.COLUMNS;';

PRINT @SQL; --Your debugging best friend
EXEC sp_executesql @SQL;


COLUMNS
01/01/2019
01/03/2019
01/04/2019


TID
878A
878A
878A

FName
user1
user1
user1

LName
user2
user2
user3


SELECT V.COLUMNS,
       MAX(CASE T.LDATE WHEN '20190101' THEN CASE V.COLUMNS WHEN N'TID' THEN CONVERT(varchar(100),[TID])
                                                            WHEN N'FName' THEN CONVERT(varchar(100),[FName])
                                                            WHEN N'LName' THEN CONVERT(varchar(100),[LName])
                                             END
           END) AS [01/01/2019],
       MAX(CASE T.LDATE WHEN '20190301' THEN CASE V.COLUMNS WHEN N'TID' THEN CONVERT(varchar(100),[TID])
                                                            WHEN N'FName' THEN CONVERT(varchar(100),[FName])
                                                            WHEN N'LName' THEN CONVERT(varchar(100),[LName])
                                             END
           END) AS [01/03/2019],
       MAX(CASE T.LDATE WHEN '20190401' THEN CASE V.COLUMNS WHEN N'TID' THEN CONVERT(varchar(100),[TID])
                                                            WHEN N'FName' THEN CONVERT(varchar(100),[FName])
                                                            WHEN N'LName' THEN CONVERT(varchar(100),[LName])
                                             END
           END) AS [01/04/2019]
FROM TEMP T
     CROSS APPLY (VALUES(N'TID'),(N'FName'),(N'LName')) V(COLUMNS)
GROUP BY V.COLUMNS;
Warning: Null value is eliminated by an aggregate or other SET operation.


ALTER TABLE TEMP ADD NName varchar(100);
INSERT INTO TEMP (TID,FName,LName,NName,LDate)
VALUES('878A','user3','user2','user4','20190501');
1 rows affected

DECLARE @SQL nvarchar(MAX);

SET @SQL = N'SELECT V.COLUMNS,' + NCHAR(13) + NCHAR(10) +
           STUFF((SELECT N',' + NCHAR(13) + NCHAR(10) +
                         N'       MAX(CASE T.LDATE WHEN ' + QUOTENAME(CONVERT(varchar(8),T.LDATE,112),'''') + N' THEN CASE V.COLUMNS ' +
                         STUFF((SELECT NCHAR(13) + NCHAR(10) +
                                       N'                                                            WHEN N' + QUOTENAME(C.COLUMN_NAME,'''') + N' THEN CONVERT(varchar(100),' + QUOTENAME(C.COLUMN_NAME) + N')'
                                FROM INFORMATION_SCHEMA.COLUMNS C
                                WHERE TABLE_NAME = N'TEMP'
                                  AND COLUMN_NAME != N'LDATE'
                                ORDER BY ORDINAL_POSITION ASC
                                FOR XML PATH(N''),TYPE).value('.','nvarchar(MAX)'),1,62,N'') + NCHAR(13) + NCHAR(10) +
                         N'                                             END' + NCHAR(13) + NCHAR(10) +
                         N'           END) AS ' + QUOTENAME(CONVERT(varchar(10),LDATE,103))
                  FROM TEMP T
                  GROUP BY LDATE
                  ORDER BY LDATE
                  FOR XML PATH(N''),TYPE).value('.','nvarchar(MAX)'),1,3,N'') + NCHAR(13) + NCHAR(10) +
           N'FROM TEMP T' + NCHAR(13) + NCHAR(10) +
           N'     CROSS APPLY (VALUES' + STUFF((SELECT N',(N' + QUOTENAME(COLUMN_NAME,'''') + N')'
                                                FROM INFORMATION_SCHEMA.COLUMNS
                                                WHERE TABLE_NAME = N'TEMP'
                                                  AND COLUMN_NAME != N'LDATE'
                                                ORDER BY ORDINAL_POSITION ASC
                                                FOR XML PATH(N''),TYPE).value('.','nvarchar(MAX)'),1,1,N'') + N') V(COLUMNS)' + NCHAR(13) + NCHAR(10) +
           N'GROUP BY V.COLUMNS;';

PRINT @SQL; --Your debugging best friend
EXEC sp_executesql @SQL;


COLUMNS
01/01/2019
01/03/2019
01/04/2019
01/05/2019


TID
878A
878A
878A
878A

FName
user1
user1
user1
user3

LName
user2
user2
user3
user2

NName
null
null
null
user4


SELECT V.COLUMNS,
       MAX(CASE T.LDATE WHEN '20190101' THEN CASE V.COLUMNS WHEN N'TID' THEN CONVERT(varchar(100),[TID])
                                                            WHEN N'FName' THEN CONVERT(varchar(100),[FName])
                                                            WHEN N'LName' THEN CONVERT(varchar(100),[LName])
                                                            WHEN N'NName' THEN CONVERT(varchar(100),[NName])
                                             END
           END) AS [01/01/2019],
       MAX(CASE T.LDATE WHEN '20190301' THEN CASE V.COLUMNS WHEN N'TID' THEN CONVERT(varchar(100),[TID])
                                                            WHEN N'FName' THEN CONVERT(varchar(100),[FName])
                                                            WHEN N'LName' THEN CONVERT(varchar(100),[LName])
                                                            WHEN N'NName' THEN CONVERT(varchar(100),[NName])
                                             END
           END) AS [01/03/2019],
       MAX(CASE T.LDATE WHEN '20190401' THEN CASE V.COLUMNS WHEN N'TID' THEN CONVERT(varchar(100),[TID])
                                                            WHEN N'FName' THEN CONVERT(varchar(100),[FName])
                                                            WHEN N'LName' THEN CONVERT(varchar(100),[LName])
                                                            WHEN N'NName' THEN CONVERT(varchar(100),[NName])
                                             END
           END) AS [01/04/2019],
       MAX(CASE T.LDATE WHEN '20190501' THEN CASE V.COLUMNS WHEN N'TID' THEN CONVERT(varchar(100),[TID])
                                                            WHEN N'FName' THEN CONVERT(varchar(100),[FName])
                                                            WHEN N'LName' THEN CONVERT(varchar(100),[LName])
                                                            WHEN N'NName' THEN CONVERT(varchar(100),[NName])
                                             END
           END) AS [01/05/2019]
FROM TEMP T
     CROSS APPLY (VALUES(N'TID'),(N'FName'),(N'LName'),(N'NName')) V(COLUMNS)
GROUP BY V.COLUMNS;
Warning: Null value is eliminated by an aggregate or other SET operation.
COLUMNS	01/01/2019	01/03/2019	01/04/2019	01/05/2019
TID	878A	878A	878A	878A
FName	user1	user1	user1	user3
LName	user2	user2	user3	user2
NName	null	null	null	user4