Repeating data when data matches

G

GARY

When the data column C matches the data in column A, I need the data
in columns C and D to be repeated for all matching rows.

For example:


This is my data:


a b c d
009701449-2 071712 009701449-2 071712
009701449-2 071712 009701452-4 008710
009701449-2 071712 009701455-7 008710
009701449-2 071712 009701460-1 008710
009701449-2 071712 009701465-6 058617
009701449-2 071712 009701467-8 059602
009701452-4 008710 009701468-9 059602
009701452-4 008710
009701455-7 008710
009701455-7 008710
009701460-1 008110
009701465-6 058617
009701465-6 058617
009701465-6 058617
009701465-6 058617
009701465-6 058617
009701465-6 058617
009701465-6 058617
009701465-6 058617
009701465-6 058617
009701465-6 058617
009701465-6 058617
009701467-8 059602
009701467-8 059602
009701467-8 059602
009701467-8 059602
009701467-8 059602
009701467-8 059602
009701467-8 059602
009701467-8 059602
009701467-8 059602
009701468-9 059002

This the result I need:

a b c d
009701449-2 071712 009701449-2 071712
009701449-2 071712 009701449-2 071712
009701449-2 071712 009701449-2 071712
009701449-2 071712 009701449-2 071712
009701449-2 071712 009701449-2 071712
009701449-2 071712 009701449-2 071712
009701452-4 071712 009701452-4 008710
009701452-4 071712 009701452-4 008710
009701455-7 071712 009701455-7 008710
009701455-7 071712 009701455-7 008710
009701460-1 071712 009701460-1 008710
009701465-6 071712 009701465-6 058617
009701465-6 071712 009701465-6 058617
009701465-6 071712 009701465-6 058617
009701465-6 071712 009701465-6 058617
009701465-6 071712 009701465-6 058617
009701465-6 071712 009701465-6 058617
009701465-6 071712 009701465-6 058617
009701465-6 071712 009701465-6 058617
009701465-6 071712 009701465-6 058617
009701465-6 071712 009701465-6 058617
009701465-6 071712 009701465-6 058617
009701467-8 071712 009701467-8 059602
009701467-8 071712 009701467-8 059602
009701467-8 071712 009701467-8 059602
009701467-8 071712 009701467-8 059602
009701467-8 071712 009701467-8 059602
009701467-8 071712 009701467-8 059602
009701467-8 071712 009701467-8 059602
009701467-8 071712 009701467-8 059602
009701467-8 071712 009701467-8 059602
009701468-9 071712 009701468-9 059602


How can I do this?
 

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

Repeating data when data matches 0
Repeating data on matching cells 0
Repeating data on matching cells 0
Repeating data on matching cells 0
Repeating data when data matches 0
Repeating cells when data matches 0
excel copy and paste... 2
Numbers from first column 6

Top