I think the fact that Richard is trying to normalize a flexible number of columns into a single column makes the Unpivot transform unsuitable.

The problem with Unpivot is that it is a transformation...