• Something like this perhaps (I'm just guessing on the rank)...

    -- Sample data

    DECLARE @table TABLE ([Year] int, Region varchar(20));

    INSERT @table VALUES (2013, 'South'), (2014, 'North'), (2015, 'South'), (2015, 'North');

    --Review:

    --SELECT * FROM @table;

    WITH

    E1 AS (SELECT N FROM (VALUES (1),(1),(1),(1),(1),(1),(1))t(N)),

    iTally AS (SELECT N = ROW_NUMBER() OVER (ORDER BY (SELECT NULL))-1 FROM E1 a, E1 b)

    SELECT [Year], Region, t = (-6 + (.25*N)), [rank] = DENSE_RANK() OVER (ORDER BY [year])

    FROM iTally

    CROSS JOIN @table

    ORDER BY [Year], Region, t-- ORDER BY Not required, including for display only, remove this for better performance

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001