Reply to thread

Message: [QUOTE="djenzovoort, post: 6251162"] 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!! [/QUOTE]