ashwinrao.k23 (8/10/2012)
Yes, I have only two group of values "A" and "B" need to be pivoted
ok...in which case the solution from rVadim will work for you.
for more info, suggest you search under the "Authors" (left sidebar) for Jeff Moden and his articles on crosstabs and pivots
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day