Thanks for all the replys!

Lynn, I read the Microsoft documentation but I thought the documentation for pivot was better than it was for Unpivot. If you know of better examples, please let me know.

Chris, thanks for the link using cross apply.

Laurie, that's just what I was looking for! I only made a small change for my purposes:

SELECT reckey, amtnumber, amt

FROM

(SELECT reckey, amt1 as [1], amt2 as [2], amt3 as [3], amt4 as [4], amt5 as [5]

FROM pvt) p

UNPIVOT

(amt FOR amtnumber IN

([1], [2], [3], [4], [5])

)AS unpvt;

Sad to say, I had something similar but I reversed some things (e.g. [1] as amt1, etc.). Thanks for setting me straight.