I've hit this several times. Step 1 is to capture the data you have into a

-- -- Create Pivot Table for final output.

-- -- drop table #pivot_columns

CREATE TABLE...