Lookup for Multiple Outputs

[greenjl7]

I have a document with a list of part numbers and the suppliers that correspond to them. There are sometimes multiple suppliers per part number. I was wondering if there was a way to spit out each supplier for only the unique values of part numbers. I know a pivot table will do this, but I need the data in a more condensed list. Attached is an example document and an example of the type of output I'm looking for.

[tigeravatar]

greenjl7,

Attached is a modified version of your posted workbook.
In cell E2 and copied down to E8 is this formula:

Please Login or Register  to view this content.

Then in cell F2 and copied over and down to I8 is this formula:

Please Login or Register  to view this content.

Does that work for you?