**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.*