We'll just keep the sharp pointy things between us... no need to involve adult supervision.
Okay, here's a question:
The current table already has an auto-number PK. So, like you said, if I preserve that in the data I unpivot, I'll have that key in my flattened table.
Now, supposing I am...