need help in dynamic pivot

• SWATH

  Old Hand

  Points: 303

  More actions

  October 3, 2012 at 7:28 am

  #265130

  Hi Everyone,,

  i have a table like

  facilityid facilityname PlannedThisMonth ActualThisMonth SpotCases

  2CHILAKALGUDA700 0 0 0

  3BOWENPALLY530 0 0 0

  4VANASATHALIPURAM730 0 0 0

  5BODUPPAL 310 0 0 0

  6MALLAPUR 350 0 0 0

  7MOULAALI 1120 0 0 0

  8KUKATPALLY530 0 0 0

  9BAGH AMBERPET210 0 0 0

  10ALWAL 290 0 0 0

  11TOLICHOWKI120 0 0 0

  12PURANAPUL 480 0 0 0

  13CHAMPAPET210 0 0 0

  the data which i have entered here is dynamic

  i need output like

  rows as columns and columns as rows

  i have tried with dynamic pivot but i didn't get the result....

  help me

  Thanks in advance

  --swat

• laurie-789651

  SSCertifiable

  Points: 7680

  More actions

  October 3, 2012 at 8:00 am

  #1544931

  Which rows as columns & columns as rows?

  You could post your expected results & what you've done so far. This might get a better answer.