Do some Excel Work - relaetd products columns

HI there I would like an excel expert to fill in a column on my spreadsheet preferably in an automated way using formulas or macros or something. The task would be to to fill in the "related products column" on this spreadsheet as it too slow to do this manually. details: I have a large product spreadsheet (8000 products+) in excel that i use on my website. in this spreadsheet you would need to understand and use 3 columns Category (already completed) Product sku (already completed) Related products (need help completing this) so i need some help with 1 of the columns only : Related products. (column AD) The products are listed into different categories (1500 categories) i.e. Column "A" in our spreadsheet determines the category the product is listed in i.e. - if we have a number 1 in column A - its a product in the red car category , if its is a number 2 in column A it would be blue cars category, number 3 would be yellow cars There are 10 "red cars" listed in the spreadsheet so all have number one listed column A in the category field Each product or red car has a unique product sku listed in Column F i.e 1045 There is a column in the excel spreadsheet - column AD - called "related products" where we can also link to related products for that product I would like an excel expert to find me an automated way using formulas or macros or something to fill in the "related products column" on this spreadsheet as it too slow to do this manually. i.e IF column A = 1/ Red cars- then column AD should contain all the products SKUs - Column F - that are linked to the category Red cars i.e. all the red cars products skus columns F - should be in column - AD The key field is the category field. This is what links the products. Ive attached some images that may explain this better and an example spreadsheet for one product that i did manually. each product sku must be seperated in column AD by a | character i.e 5367|5368|5369|5370|5371|6979|6980|6981|6982|6983|7309|7348