Question description:
This user has given permission to use the problem statement for this
blog.
Hello, I need help on sorting a rather large list. It is data with people's names and things they purchased.
COLUMN A: Items Purchased
COLUMN B: FIRST NAME
COLUMN C: LAST NAME
For every item purchased, is another row even if it's the same person. So:
Doll Abbi Sumandal
Toy Abbi Sumandal
I'm trying to find a way for Excel to recognize duplicates in columns B&C (Abbi Sumandal) and take the unique values and set them in the same row. Final:
Abbi Sumandal Doll Toy
Is there a formula or function that can do this?!
Solved by V. H. in 26 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
25/07/2018 - 04:52
Hello?
Excelchat Expert
25/07/2018 - 04:52
Hi
Excelchat Expert
25/07/2018 - 04:53
Welcome to Got it Pro
User
25/07/2018 - 04:53
How are you. I was wondering if you could help me with a problem i'm having
Excelchat Expert
25/07/2018 - 04:53
Please tell more about the requirement so that i can help you better
User
25/07/2018 - 04:53
I'm trying to figure out how to filter column A based on the information on Columns B & C
User
25/07/2018 - 04:53
So that i can take that data and put it all on one row
User
25/07/2018 - 04:54
I'm not sure if you can see the document preview
Excelchat Expert
25/07/2018 - 04:54
Yes i can see it
Excelchat Expert
25/07/2018 - 04:54
Can you share more data on it so that i can understand better
User
25/07/2018 - 04:54
Sure so i've gotten data from a store
User
25/07/2018 - 04:55
the first column lets say is items purchased but it logged in all of it individually
User
25/07/2018 - 04:55
so there will be a unique row for every item purchased even if it's the same person
User
25/07/2018 - 04:55
how do i consollidate that information so that everything that occurs for the same person repopulates to a single row
User
25/07/2018 - 04:55
of that owner
User
25/07/2018 - 04:58
So like with every occurance of Abbi Sumandal, the items in column A are grouped together
Excelchat Expert
25/07/2018 - 04:58
Yes i understand
Excelchat Expert
25/07/2018 - 04:58
Let me help you out with the formula
Excelchat Expert
25/07/2018 - 05:06
Please have a look on sheet 2
Excelchat Expert
25/07/2018 - 05:06
Let me know if you understand that
User
25/07/2018 - 05:06
no
User
25/07/2018 - 05:06
lol i need to be walked through
User
25/07/2018 - 05:06
sorry
Excelchat Expert
25/07/2018 - 05:07
I just concatenated the filed column B and C
Excelchat Expert
25/07/2018 - 05:07
and against that i am pulling column E which is same as column A
User
25/07/2018 - 05:07
okay
Excelchat Expert
25/07/2018 - 05:08
Let me know if that helps
User
25/07/2018 - 05:08
and did you sort based on column D?
User
25/07/2018 - 05:08
OH there it is
User
25/07/2018 - 05:09
i was like wait lol where's the formula
Excelchat Expert
25/07/2018 - 05:09
Not basis column D, it is fetching value against column D matching it with D13
Excelchat Expert
25/07/2018 - 05:09
Did you understand?
User
25/07/2018 - 05:09
Sort of
Excelchat Expert
25/07/2018 - 05:09
I hope this session is helping you
Excelchat Expert
25/07/2018 - 05:10
Please do give good rating and reviews..it would help a lot
User
25/07/2018 - 05:10
Yeah of course no problem
User
25/07/2018 - 05:10
So... You combined the info from B&C to make column D... and the array forumla goes through that column and any dupes it takes row E and copies it to row 13?
Excelchat Expert
25/07/2018 - 05:11
Yes exactly
User
25/07/2018 - 05:12
oh okay. So if use that formula and there are different ones
User
25/07/2018 - 05:12
Different first last names
Excelchat Expert
25/07/2018 - 05:12
Yes you can
User
25/07/2018 - 05:12
Would i have to use this formula for every unique instance?
User
25/07/2018 - 05:12
Lets say
Excelchat Expert
25/07/2018 - 05:12
combine them like i did and use the same formula
User
25/07/2018 - 05:13
BAH lol can you show me?
User
25/07/2018 - 05:14
is that too much to ask
User
25/07/2018 - 05:14
? hahah i don't mean to be that annoying noob
Excelchat Expert
25/07/2018 - 05:17
See now
User
25/07/2018 - 05:17
Oh okay. Yes I did
User
25/07/2018 - 05:18
Thank you so much! That was super helpful!
User
25/07/2018 - 05:18
I'll be sure to get you a good rating! Thanks!
Excelchat Expert
25/07/2018 - 05:18
Welcome
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.