Sue,

I had to pull the data into Excel via Oracle to get the desired output. I did however, attempt to aggregate the data into a view thinking that would help but referring back Excel, I was able to make it happen. Thanks for the help.