On Thursday, June 4, 2015 at 3:23:29 PM UTC+5:30, Nitya Satheesh wrote:
hi!,
this is what my data looks like,

A B
1 a
1 b
1 b
3 b
3 b
3 c
4 b
4 b
5 d
6 e
7 d

now i need to display all unique values of column a but that should include all repeated values of column b.

so for example, if column a has 1 it should display both 'a' and 'b'. now i know i can take unique values but that doesn't really work because for 1 the corresponding value that is displayed is only 'a'.

Please help !

So my new data should look somewhat like this
1 a
1 b
3 b
3 c
4 b
5 d
6 e
7 d