I have the following results from my query. Switch Lead Prefix Fnum Lnum NumberOfOE MDAType ALMA 418-256 LDOR 1 1 9 WKG-NA ALMA 418-256 LDOR 2 0 8 WKG-NA ALMA 418-256 LDOR 2 1 2 WKG-NA ALMA 418-256 LDOR 3 0 8 WKG-NA ALMA 418-256 LDOR 3 1 3 WKG-NA ALMA 418-256 LDOR 6 0 1 WKG-NA ALMA 418-256 LDOR 7 0 2 WKG-NA ALMA 418-256 LDOR 7 0 1 WKG-PA ALMA 418-256 LDOR 7 1 1 ADV
And I wish to come to something like this: Switch Lead Prefix Fnum Lnum WKG-NA WKG-PA ADV ALMA 418-256 LDOR 1 1 9 0 0 ALMA 418-256 LDOR 2 0 8 0 0 ALMA 418-256 LDOR 2 1 2 0 0 ALMA 418-256 LDOR 3 0 8 0 0 ALMA 418-256 LDOR 3 1 3 0 0 ALMA 418-256 LDOR 6 0 1 0 0 ALMA 418-256 LDOR 7 0 2 1 0 ALMA 418-256 LDOR 7 1 0 0 4
It is like a pivot on columns NumberOfOE and MDAType... Any Idea? Thanks!
Rows to Columns Results
Posted - 02/11/2013 : 13:58:15
