Ok, thanks again. Happy Holidays.

Yes and the Value field is varchar(02), it needs to hold "1", "2", or "NA".

Ok thank you for sharing information.

It's for a clinical situation. I guess later it can be delivered as a .csv. For now my manager wants to review data and he wants to see it in...

I mean I can on my last day and my last minute of my contract..........lol

Sorry, you're right.

This is what the "base table" I have looks like.

There will be over 2 million IDs and each ID will have the same exact set...

Sorry, I thought I was clear.

I have to take each ID that has 7000+ records, update them (which I have to figure out) per ID, then pivot the results.

Each ID...