I have a dataframe of 3 columns as below
batsman1 bowler1 timesOut
1 A Ashish Reddy A Ashish Reddy 0
2 A Ashish Reddy A Chandila 1
3 A Ashish Reddy A Choudhary 3
4 A Ashish Reddy A Dananjaya 0
I would like to transform the above dataframe where the second column becomes column names as below
batsman1 A Ashish Reddy A Chandila A Choudhary A Danajaya
A Ashish Reddy. 0 1 3 0
A Chandila
A Choudhary
A Danajaya