Compressing multiple rows down to one row by using a common field

Hi
I have created a report in corvu and am unable to show it the way i need it and was hoping there was a solution in excel that i could use.

I have attached a small example of what i want which contains 3 rows that i need to compress down to 1 row. In my finished report i have over 250000 rows so i cant really do it manually a row at a time.

I cant find any decent corvu forums which is why i have come to excel as it is much more widely supported.

thanks

Try the attached

HI Jindon

Your a genius, that did the trick. Where can I learn more about the code you used so I can understand how it does what it does?

You have saved me hours of work, thank you very much for taking the time to reply.

Cheers

Thanks for the feedback.

Used Array and Dictionary object.
Dictionary object is in Excel Help and you will see many good web sites, too.