Problem in displaying query results

Hi all,

I Started laerning coldfusion recently.
I have created a coldfusion file which has a query which retrieves duplicate records.

I want to display the repeted values only once.

i.e

name age subject
----------------------------------------------------------------------
x 21 s1
x 21 s2
x 21 s3
y 22 s2
y 22 s1

I want to display above results in below format


subject age name
----------------------------------------------------------------------
s1 21 x
s2
s3
-----------------------------------------------------------------
s2 22 y
s3



how colud i display the results in above format?
Please resolve this issue.



Thanks in advance.