Supplier List

[carrrrlitos17]

I want to make a data base for suppliers I potentially have. On the table portion I have the companies, contact name, contact email, and contact phone number listed out. (Check out img Table) The issue I currently face is that companies provide more than one needed product. I want to make another sheet where it simplifies and combines the info I have in the table by company. First I used UNIQUE to list out all the companies. Then I used a TEXTJOIN and FILTER function I found online to list every item in one cell (Check Other Sheet Image). The problem occurs when I try going into Contact and Email and telephone, I used the same formula standard as I did for goods/services but of course, get duplicate contacts, when I just want it to show it once. Sadly, certain contact info is missing from companies, so I can't use UNIQUE.

All in all essentially, I need a way to list the contact's name according to the company, and leave it blank if it is blank and move to the next row.

 

[Fluff]

Hi & welcome to MrExcel.
You can use Unique, as long as you put "" as the 3rd argument in the Filter function.
If you need help with that please post your formula.

 

[carrrrlitos17]

Hi & welcome to MrExcel.
You can use Unique, as long as you put "" as the 3rd argument in the Filter function.
If you need help with that please post your formula.

Sorry not sure if I understood, I currently have =TEXTJOIN(CHAR(10),,FILTER(Table2[Contact],Table2[Company]='Supplier Breakdown'!A3)) in Column C. But it is giving me duplicate info as is shown in the column in "New Sheet"

 

[Fluff]

How about

=TEXTJOIN(CHAR(10),,UNIQUE(FILTER(Table2[Contact],Table2[Company]=A3,"")))

You should never refer to the name of the sheet the formula is on

 

[carrrrlitos17]

How about

=TEXTJOIN(CHAR(10),,UNIQUE(FILTER(Table2[Contact],Table2[Company]=A3,"")))

You should never refer to the name of the sheet the formula is on

Brilliant that did the trick! I didn't even realize it referred to the sheet, I was just clicking. Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.