Can you convert the output of a EXEC sp_executesql into view or table

Question

The SQL below does exactly as expected, turns a fields which contains multiple tests all separated by a coma, groups then by Id and turns the Tests into Column headings and return a 1 or 0 depending if the person (Id) had that test recorded in the field mentioned.

Ideally I'd have this as a view but as it's data driven there is a chance it changes over time (new tests that are performed etc).

DECLARE
@cols AS NVARCHAR(MAX),
@y    AS INT,
@sql  AS NVARCHAR(MAX);
-- Construct the column list for the IN clause
SET @cols = STUFF(
(SELECT N',' + QUOTENAME(y) AS [text()]
FROM (
        SELECT DISTINCT UPPER(TestsPeformed.value) AS y FROM badger.[Mother_DIGN_BloodTestsAndResults]
        CROSS APPLY STRING_SPLIT(TestsPeformed, ',') as TestsPeformed
        GROUP BY TestsPeformed.value
            ) AS Y
ORDER BY y
FOR XML PATH('')),
1, 1, N'');

-- Construct the full T-SQL statement
-- and execute dynamically
SET @sql = N'
select * into #tbl 
from ( SELECT EntityID, UPPER(TestsPeformed.value) as Test
        FROM badger.[Mother_DIGN_BloodTestsAndResults]
            CROSS APPLY STRING_SPLIT(TestsPeformed, '','') as TestsPeformed
        GROUP BY EntityID, TestsPeformed.value
    ) t(EntityID, s);

select *
from #tbl
PIVOT (
  COUNT(s)
  FOR s IN(' + @cols + N')) AS P;';

EXEC sp_executesql @sql;
GO