How to combine duplicate data into one row from Column A to Column B

**AnnaMarie88** · 08-01-2012, 03:47 AM

Column A is the product codes and column B is the category numbers, I have to tell the new system which categories to assign the items to.
Unfortunately to import the data into the new system there can only be one of each product code in column A

So at the moment the data is like this

A B
1 4561
1 1561
1 1652
2 1456
2 1574
2 2252
3 1485
4 1235
4 4565

but I need to change the data to only one of each code in column A with the various column B options comma delimited, like this. The data will not transfer if there are duplicate entries in column A.

A B
1 4561,1561,1652
2 1456,1574,2252
3 1485
4 1235,4565

I badly need help as soon as possible. Your help will be highly appreciated.

**benishiryo** · 08-01-2012, 04:21 AM

hi AnnaMarie88, welcome to the forum. i created a template for you. All you have to do is copy your whole date & paste values in A2. if done correctly, the data should be coloured like my existing one in blue & white. then copy E2:J2 down until column E reads #N/A. that means there are no more unique numbers. in my eg. the unique list ends at 4. your desired result should be in Column J. and i dont know how many times your "B" can show up. your eg shows 3, i added a 4th just in case.

**AnnaMarie88** · 08-01-2012, 04:47 AM

Hello benishiryo!

Thank you for the warm welcome. I deeply appreciate your help. I am so happy that the template you've made is working. Thank you very very very very much!

**Cutter** · 08-01-2012, 08:39 AM

@ AnnaMarie88

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

**AnnaMarie88** · 08-01-2012, 11:18 AM

Originally Posted by benishiryo

hi AnnaMarie88, welcome to the forum. i created a template for you. All you have to do is copy your whole date & paste values in A2. if done correctly, the data should be coloured like my existing one in blue & white. then copy E2:J2 down until column E reads #N/A. that means there are no more unique numbers. in my eg. the unique list ends at 4. your desired result should be in Column J. and i dont know how many times your "B" can show up. your eg shows 3, i added a 4th just in case.

Hello benishiryo!

I just have another problem. I need this excel file to be saved as csv format without altering the comma placement of the category numbers. Kindly help me please.

---------- Post added at 03:18 PM ---------- Previous post was at 03:17 PM ----------

Originally Posted by Cutter

@ AnnaMarie88

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Noted! Thank you for the reminders.

**benishiryo** · 08-01-2012, 09:58 PM

you are very welcome~ and thanks for the rep.

save it in another filename & paste values for them. now that they are not linked to each other, delete the unnecessary data & save as csv?