Client Nr Client Nm Exec Account Rep
022220 J.P. William Rana
022220 J.P. William Loughlin
022220 J.P. William Travalja

I would like to pivot the above below to read as the below (Keeping the main
Client NR as the main pivot, I need each account rep to be a indepedent
column and not duplicate.)

Client NR Client Nm Exec Account Rep1 Account Rep2 Account
Rep3
022220 J.P. William Rana Loughlin Travalja


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200508/1