Transpose Data

[nkr306_nkrs]

Hello Everyone

Can some one please help me convert the below Data

Name	Code	Age	Gender	Rank	Placing
CTPT	BT5	15
CSH	BBD	20
DPL	918	115	M	1236	36
DPL	918	115	F	1236	36.4
DPL	918	115	F	4589	36.4
LMP	BW7	1113	M	21498	1.757
LMP	BW7	1113	M	203476	1.757

To this

Name	CTPT	CSH	DPL	LMP
Code	BT5	BBD	918		BW7
Age	15	20	115		1113
				-		-
Gender if 'M'(Rank & Placing)	-	-	1236	36	21498	1.757
					203476	1.757
Gender if 'F'(Rank & Placing)			1236	36.4
			4589	36.4