Rows into Columns

• Anshu Dev

  SSC Enthusiast

  Points: 127

  More actions

  October 6, 2010 at 7:13 am

  #224727

  Hi All,

  Actually I have a table which stored data in column format .

  For Eg. table luks something like this :

  ID Name Question Response

  1 Alex Ques1 Res1

  1 Alex Ques2 Res2

  1 Alex Ques3 Res3

  2 Arian Ques1 Res1

  2 Arian Ques2 Res2

  3 Jim Ques1 Res1

  Now I am making a report on this data. The desired outpput is :

  1 Alex Ques1 Resp1 Ques2 Res2 Ques3 Res3

  2 Arian Ques1 Res1 Ques2 Res2

  3. Jim Ques1 Res1

  So its kind of converting the different value columns of same person into columns instead of rows.

  I cannot change the table structure . I just need the query which does that so that I can use it in SSRS

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734449

  More actions

  October 6, 2010 at 8:15 am

  #1232584

  Look up cross tab report or PIVOT.