View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
coeus coeus is offline
external usenet poster
 
Posts: 7
Default Can I use vlookup to do this?

I have a sheet like below:
aaa 1
bbb 2
bbb 3
ccc 4
ddd 5
ddd 6
ddd 7
Now I want to reorganize the table like below:
aaa 1
bbb 2,3
ccc 4
ddd 5,6,7
What should I do? Thanks a lot!