duplicate vlookup help

[saif49]

Hi,

I have a file containing item code and its delivery date.
1 15-sep-10
1 30-oct-10
2 15-sep-10
3 21-nov-10
4 16-oct-10
4 21-oct-10
4 07-nov-10
5 31-oct-10

and i need this data to be in the format

1 15-sep-10 30-oct-10
2 15-sep-10
3 21-nov-10
4 16-oct-10 21-oct-10 07-nov-10
5 31-oct-10

I tried using vlookup but it only returns the first entry. Tried many alternatives with IF statements and Index and match but couldnt get it.

Can someone please help with this?

Thanks,
Saif

[EINSTEIN_007]

Have you tried changing the reference of VLOOKUP's table_array to exclude the previously found item. I am not sure if this helps you, but you may be able to use "AutoFilter" under the menu.

Data
Filter
Autofilter

This would allow you to show only the items that have in the first column.