1
Answer

data in more columns should be get into single column

Karthik G

Karthik G

8y
296
1
i have one table like
 col_1 col_2 col_3 col_4
 aa dd gg jj
 bb ee hh kk
 cc ff ii ll
 
 
but i want the result as
 
  
Column1 Column2 Column3 Column4
col_1 col_2 col_3 col_4
aa dd gg null
bb ee hh null
cc ff ii null
dd gg jj null
ee hh kk null
ff ii ll null
gg jj null null
hh kk null null
ii ll null null
jj null null null
kk null null null
ll null null null
 
 please any one can answer to this .
Answers (1)