Hello,
I have a list (list 1) with 100+ names of companies, many of them repeating. I am trying to make a new list (list 2) that has each of the companies in list 1 just listed once in list 2. And in list 2 it will automatically add any new companies that are put into list 1 into list 2.
I have made an example below:
List 1:
-List 1 has the breakdown of the Types of foods (company) and the amount of each that the person has.
List 2:
-List 2 is suppose to take the type of food in list 1, display it once and add any new foods that are currently not in list 2.
Issue:
-If I add a new food into list 1 like pasta, what formula do I use in list 2 to make it show up ? I understand how to do the amount column for list 2. I am just really confused on how to do the food column for list 2
I have a list (list 1) with 100+ names of companies, many of them repeating. I am trying to make a new list (list 2) that has each of the companies in list 1 just listed once in list 2. And in list 2 it will automatically add any new companies that are put into list 1 into list 2.
I have made an example below:
List 1:
| Type of Food | Person its from | Amount |
| Apples | betty | 3 |
| Apples | george | 4 |
| Oranges | cassie | 2 |
| Burger | lucy | 1 |
| Fries | matt | 3 |
-List 1 has the breakdown of the Types of foods (company) and the amount of each that the person has.
List 2:
| Food | Amount |
| Apples | 7 |
| Oranges | 2 |
| Burgers | 1 |
| Fries | 3 |
-List 2 is suppose to take the type of food in list 1, display it once and add any new foods that are currently not in list 2.
Issue:
-If I add a new food into list 1 like pasta, what formula do I use in list 2 to make it show up ? I understand how to do the amount column for list 2. I am just really confused on how to do the food column for list 2
