Hi,

This is really doing my head in!

I am trying to find some macro code to enable me to do the below. Any help with this would be greatly appreciated.

RAW DATA:


ID MATERIAL1 MATERIAL2 MATERIAL3 MATERIAL4 MATERIAL5
1 METBB1
1 METBB1
1 METBB2
2 METBB3
3 METBB1
3 METBB1

REQUIRED DATA:

ID MATERIAL1 MATERIAL2 MATERIAL3 MATERIAL4 MATERIAL5
1 METBB1 METBB1 METBB2
2 METBB3
3 METBB1 METBB1


Please help??

David