Table Groups

KavithaD

Hi,
I am having table Table1,Col1,Col2,Col3,Col4.Actually i am displaying values like below,
Col1 Col2 Col3 Col4
A 1 a aa
A 1 b bb
A 2 c cc
A 3 d dd
B 4 a aa
B 4 b bb
B 5 c cc
B 5 d aa
B 6 e bb

But I want to display values something like this just want to avoid duplicates in table,

col1 col2 col3 col4

A 1 a aa
cc

b bb

A 2 c cc
3 d dd

B 4 a aa
b bb

5 c cc
d aa

6 e bb

Please let me know how to achieve this?

KavithaD

Attaching screen shot..