Find duplicates and append

H

HUBBUB88

Hi one and all

Want to do a look for duplicate and if yes then append data.

Example

Column 1 Column 2
1234 product1
1234 product 2
1234 product 3

i would like it find where column 1 contains a duplicate then if ye
append the data or copy it into column 2, and 3 and 4

Column 1 Column 2 Column 3 Column 4
1234 product1 product 2 product 3
1234 product 2
1234 product 3


Possible?


Thanks

If possible also to mark in column 5 as a dup like this


Column 1 Column 2 Column 3 Column 4 Column 5
1234 product1 product 2 product 3
1234 product 2 Dup
1234 product 3 Du
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with time function 7
List all tables, including document structure 0
Vlookup and retrieve values 1 row below the normally retrieved val 2
Trying to count based on multiple criteria & cell comparisons 4
Offset/Match Double Lookup 4
Find Duplicates and Append 2
Append data if a duplicate found 0
Look up a text value then count records < a date 3

Top