Query to change rows into columns and vice versa

• KK-375826

  SSC Veteran

  Points: 287

  More actions

  November 13, 2007 at 3:38 pm

  #200439

  If the query output is shown the table below (including the column names in the first row).

  ABCDE

  a1b1c1d1e1

  a2b2c2d2e2

  a3b3c3d3e3

  a4b4c4d4e4

  a5b5c5d5e5

  The table needs to be converted to (the rows become columns and columns become rows).

  Aa1a2a3a4a5

  Bb1b2b3b4b5

  Cc1c2c3c4c5

  Dd1d2d3d4d5

  Ee1e2e3e4e5

  Thanks

  KK

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  November 14, 2007 at 6:29 am

  #751061

  Use PIVOT operator.