Hi I have to transpose rows to columns
I have simple table like below
ID REQUESTID ACTION_MEMBER_ID 1 1 10 2 1 15 3 2 11 4 2 12
I want to convert to
REQUESTID AMID1 AMID1 1 10 15 2 11 12
Kindly let me know how can i do this, i tried code snippets but all with max,sum,count functions.Action members can be dynamic,so the columns should arrange according to that