I have used dynamic sql to create the required query ( as transio listed ) based on the values to be transposed. Still have not found a way to do it in single written sql statement