hI

I have got some information laid out like follows

col1 col2 col3 col4
1 name 1 ytr ytr
1 name 1 ytr ytr
1 name 1 ytr ytr
2 name 2 ytr ytr
2 name 2 ytr ytr
3 name 3 ytr ytr
3 name 3 ytr ytr
3 name 3 ytr ytr

i need to get it like this -

col1 col2 col3 col4
1 name 1 ytr ytr
2 name 2 ytr ytr
3 name 3 ytr ytr
1 name 1 ytr ytr
2 name 2 ytr ytr
3 name 3 ytr ytr
1 name 1 ytr ytr
3 name 3 ytr ytr

another approach would be ok to make it so there are no
duplicates in line 1 but it must only be in line 1
therefor the above list would go like

col1 col2 col3 col4
1 name 1 ytr ytr
2 name 2 ytr ytr
3 name 3 ytr ytr

thanks - I hope you get what i mean

ann