Thank you for the reply Sean. I will make sure to post the ddl and sample data in the future.

The example you've provided is interesting. I've never thought of doing it like that, but I do need this to be a dynamic pivot. I should have specified that in the original post. There may be up to 250 total columns.

-Jeremy