Union fieds in a query : I Have table with A1,A2,A3,A4,B1,B2,B3,B4 fields. I need a select statement that union field : A1 and B1 in C1, A2 and B2 in C2,A3 and B3 in C3,A4 and B4 in C4

 FOR EXAMPLE 
 TABLE ONE

     A1 A2 A3 A4 B1 B2 B3 B4
     1  1  1  1  0  0  0  0
     2  2  2  2  0  0  0  0
     0  0  0  0  3  3  3  3 

 I NEED RESULT LIKE THIS
 TABNE TWO

    C1 C2 C3 C4 
     1  1  1  1
     2  2  2  2 
     3  3  3  3

 Thanks in advance . 