SELECT DISTRICT_STUDENT_ID,	
         STATE_STATE_ID,	
         FIRST_NAME,
	LAST_NAME,
MAX(CASE WHEN SHORT_DESCRIPTION = 'WEIGHT' THEN SCORE END) AS WEIGHT,
MAX(CASE WHEN SHORT_DESCRIPTION = 'HEIGHT' THEN SCORE END) AS HEIGHT,
MAX(CASE WHEN SHORT_DESCRIPTION = 'CURL_UPS' THEN SCORE END) AS CURL_UPS,
MAX(CASE WHEN SHORT_DESCRIPTION = 'SIT_REACH' THEN SCORE END) AS SIT_REACH,
MAX(CASE WHEN SHORT_DESCRIPTION = 'MILE' THEN SCORE END) AS MILE,
DATE_ENTERED
FROM
(
SELECT ROW_NUMBER() OVER (PARTITION BY DISTRICT_STUDENT_ID,	
         STATE_STATE_ID,	
         FIRST_NAME,
	LAST_NAME
ORDER BYDATE_ENTERED DESC) AS Rn,*
FROM table
)t
WHERE Rn=1
GROUP BY DISTRICT_STUDENT_ID,	
         STATE_STATE_ID,	
         FIRST_NAME,
	LAST_NAME,
DATE_ENTERED