I have a very large worksheet that is seperated between item codes and the
categories related to those items. However, the way the worksheet comes
pre-formated:

3160WW AUD3000
3160WW AUD4000
3160WW AUD6000
3170WX SAM1300

I want to move all the related categories into seperate fields:

3160WW AUD3000 AUD4000 AUD 6000
3170WX SAM1300

How do I do this in excel? I know access a little if I need to do it in that.
Also I would want to add the additional text "PC" to the item codes: PC3160WW


Thanks, please send me an e-mail if you have a fix to this delima at
pcelite2 @ (no spam) yahoo.com THANKS.