D
djenzovoort
Hello, i have a question:
Column A: Column B:
name1 text
name1 text
name2 text
name3 text
name2 text
name2 text
name2 text
name1 text
name2 text
name2 text
name4 text
name4 text
name4 text
name5 text
name5 text
etc
I want to find all duplicate values in column A and if found copy the
values in B to different columns
Result:
A B C D E F
Name1 text text text
Name2 text text text text text
etc
Hopefully someone can help me because i have a long list and doing by
hand would take forever!
Thanks in advance!!
Column A: Column B:
name1 text
name1 text
name2 text
name3 text
name2 text
name2 text
name2 text
name1 text
name2 text
name2 text
name4 text
name4 text
name4 text
name5 text
name5 text
etc
I want to find all duplicate values in column A and if found copy the
values in B to different columns
Result:
A B C D E F
Name1 text text text
Name2 text text text text text
etc
Hopefully someone can help me because i have a long list and doing by
hand would take forever!
Thanks in advance!!