The thing of the data is this. I have no idea what will be in that column, so a case statement will not work, that I see.

And there are many other UserIDs in this table.

I need to make the value become a column name, and then the other value be the data in that column for that particular UserID.

Thanks

Andrew SQLDBA