i have my data as below and I need a macro wich can produce my output, please help out immediatly.
MY iNPUT:
kumar aaa
kumar bbb
kumar ccc
jack lllll
numb ddd
numb www
numb ttttt
alan vvv
bany vbada
sunny gagdsass

my output should be: duplicate adjacent values should be lined up to first value with all the duplicate values in a single row.
Kumar aaa bbb ccc
Jack llll
numb ddd www ttttt
alan vvv
bany vbada
sunny gagdsass