You need to unpivot data. See:
Using PIVOT and UNPIVOT - SQL Server | Microsoft Docs[
^]
WITH CTE AS
(
SELECT Indicator, [Val], [ColNo]
FROM
(
SELECT [13] AS Indicator, [17], [18], [19], [110], [111], [112], [113]
FROM TESTE
) AS PVT
UNPIVOT
(
[Val] FOR [ColNo] IN ([17], [18], [19], [110], [111], [112], [113])
) AS UNPVT
)
SELECT B.Indicator, A.[Val] AS DateVal, B.[Val]
FROM CTE AS A
INNER JOIN CTE AS B
ON A.[ColNo] = B.[ColNo]
WHERE A.Indicator = 'INDICATORS'
AND B.Indicator <> 'INDICATORS';
SQL Server 2019 | db<>fiddle[
^]