Data Orientation Problem

Hello,
I have a need to present a different orientation of data, and I would normally do this with CASE. I've tried to go that route in this instance, but it hasn't worked.

The following query expresses the data as it currently is:


SELECT TOP 10
Prod,
Acct,
TC,
SubmitRep1,
SubmitRep2,
SubmitRep3,
Percent1,
Percent2,
Percent3
FROM
dbo.tbl_CYProcessedSales
WHERE
Proj IN (100,200)
AND Percent1 < 80
AND NOT SubmitRep3 = ''
AND Prod = 'RETA'

The result looks like this:

Prod Acct TC SubmitRep1 SubmitRep2 SubmitRep3 Percent1 Percent2 Percent3
RETA PA0065 T2 OJOYNER CAPARRSH SBEVERLY 34 33 33

I need for the result to come out like this:

Prod Acct TC Rep Percentage
RETA PA0065 T2 OJOYNER 34
RETA PA0065 T2 CAPARRSH 33
RETA PA0065 T2 SBERVERLY 33


Do I want to use CASE here, or a cross join?

Thank you for your help!

cdun2