May 29, 2009 #1 dechrist Programmer Sep 24, 2008 10 US I have the following in a table in Teradata (the actual table has about 60 columns): Dept Group Col1 Col2 100 1 A D 100 2 B E 200 1 C F I would like to get: Dept 100 100 200 Group 1 2 1 Col1 A B C Col2 D E F
I have the following in a table in Teradata (the actual table has about 60 columns): Dept Group Col1 Col2 100 1 A D 100 2 B E 200 1 C F I would like to get: Dept 100 100 200 Group 1 2 1 Col1 A B C Col2 D E F