SQL Question: Pivots, Analytics and the judicious use of Row_Number()

A few days ago I answered a question from brat about converting 1 field into multiple rows. We solved that question but now we want to handle multiple rows in our source table.

Just a note of warning. This article will really make a lot more sense if you follow along in SQL*Plus, TOAD or some other tool and if you run through the other article first.