searching around this site but does not see any similar and helping thread.

Example: I have a data as below

```
Col1       Col2
aaaa       1111
aaaa       2222
bbbb       4444
bbbb       3333

```

How can I query to have a table like below ?

```
Col1       Col2
aaaa       1111
           2222
bbbb       4444
           3333

```

My current query to test this purpose

```
SELECT Col1,Col2 FROM msaEPGerror 
FROM Table1
GROUP BY Col1,Col2

```

Tried using distinct and group by, but it still showing the other data as well. Yeah my db contained over hundred thousand of lines.
Is it possible ? I'm just trying my luck since previously I design thing using Report Builder, but now trying to migrate it to SQL.

Thanks