Hi, I'm looking to extract the supplier info from the below sample table.
I would like to format the info as per the below:
Is there a formula for this?
Ingredient | Supplier |
Apples | Schroeders |
Oranges | McCarthys |
Apples | Peters |
Tomatoes | McCabes |
Oranges | Thomassons |
Oranges | Hendersons |
I would like to format the info as per the below:
Is there a formula for this?
Ingredient | Supplier 1 | Supplier 2 | Supplier 3 |
Apples | Schroeders | Peters | |
Oranges | McCarthys | Thomassons | Hendersons |
Tomatoes | McCabes |