ashish gupta

ashish gupta

  • NA
  • 94
  • 0

Convert Rows to Column

Jul 10 2018 6:24 AM
I am getting output from my query is :-
 
Dt Column Column1
2018-07- 09 Wet & dry1 2/2
2018-07-09 Back Pack 4/5
2018-07-09 Ride on 4/8
2018-07-09 Walk behind 4/4
2018-07-09 Test 3/6
 
I want result in below format :-
 
Dt Wet & dry1 Back Pack Ride on Walk behind Test
2018-07-09 2/2 4/5 4/8 4/4 3/6
 
Please help ,and column is dyamic.

Answers (3)