Answered step by step
Verified Expert Solution
Question
1 Approved Answer
EXCEL - I would like to have a formula that would show all the elements from one list into one single row in another list.
EXCEL - I would like to have a formula that would show all the elements from one list into one single row in another list.
For example I have a list of clients
Name | |
Client 1 | |
Client 2 | |
Client 3 | |
Client 4 | |
Client 5 | |
Client 6 | |
Client 7 |
and a list of fruits showing the fruit that each client bought:
Name | Fruits |
Client 1 | Oranges |
Client 1 | Apples |
Client 1 | banana |
Client 2 | Oranges |
Client 2 | banana |
Client 2 | Kiwi |
Client 3 | Oranges |
Client 3 | kiwi |
Client 3 | apples |
Client 4 | apples |
Client 5 | apples |
Client 6 | Banana |
Is there a formula that would show all the items bought in the clients list?
like this ( or similar to this):
Name | Purchases | ||
Client 1 | Oranges, apples, Banana | ||
Client 2 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started