Here's an option that should work fairly well. 
SET QUOTED_IDENTIFIER ON;
GO
SET ANSI_NULLS ON;
GO

CREATE FUNCTION dbo.tfn_ProperCase
/* ===================================================================
05/02/2018 JL, Created:
                This function...

Here is an example of a dynamic cross tab (similar to what's described in Jeff's 2nd link)
IF OBJECT_ID('tempdb..#TestData', 'U') IS NULL
BEGIN    -- DROP TABLE #TestData;
    CREATE TABLE #TestData (
        SRV...