Rank: Member Groups: Member
Joined: 11/9/2007 Posts: 22 Points: 66 Location: Sunderland
|
I would like to change rows into columns and columns to rows for the query output table
If the query output is like shown in the table below (including the column names in the first row).
A B C D E a1 b1 c1 d1 e1 a2 b2 c2 d2 e2 a3 b3 c3 d3 e3 a4 b4 c4 d4 e4 a5 b5 c5 d5 e5
The table needs to be converted to (the rows become columns and columns become rows).
A a1 a2 a3 a4 a5 B b1 b2 b3 b4 b5 C c1 c2 c3 c4 c5 D d1 d2 d3 d4 d5 E e1 e2 e3 e4 e5
Thanks
|