Merge Duplicate Rows in Excel Combining Unique Values in One Cell

[@davidl.2991]

I have looked up this same question so many times. This is the first video that has actually helped! Thank you!

[@IvanCortinas_ES]

Yeah. Solid explanation Chester. Excellent resolution with Power Query using Text.Combine. Thank you!!!

[@cheezeandcrackers]

Merging into a single sell seems like it would be hard to manipulate the data later. How do you combine, but put the data in separate columns?

[@abdessamadchokri352]

with this Power Query , You just save my life, Thank youu!!

[@kimodoe]

You just saved me a lot of time thank you so much

[@kathidavis5220]

Thank You! This saved me so much time!

[@andrieswilhelmusroesch4667]

This was amazing and saved me a lot of work, thank you very much

[@youasterix]

Gracias Chester!! excelente información.

[@Tanya-zc7ro]

This is exactly what I was looking for! *except* I have multiple columns that I still need to show. They aren't being combine or anything, but I just need to see them. Is there a way to do that? Thanks so much

[@this.is.ak.]

You just earned a sub!

[@LuciaSnoei]

Dang. So clear! Thank you.

[@erhaneren2122]

Great job. 👌

[@sarahdorsett9658]

This amazing - thank you so much

[@djl8710]

Thanks Chester, I didn't think to try the IF I was using this version since they updated the array grid. =TEXTJOIN(", ",TRUE,FILTER(B2:B20,A2:A20=D1,""))

[@gurmeetsingh6801]

Very helpful thankyou

[@franckhermann9071]

Thank you so much. Does it work also with numbers.

[@BankerWriterMosharaf]

Please make a video on how to replace series of Duplicate Values with Blanks / Zeros while retaining the first occurrence or last occurrence

[@peterkortvel]

so complicated. but i made it. thanks!!!

[@gypsy12101506]

Thank You!!!

[@dieselfox9879]

Hi there. This is great! What if the 'Books Read' column is numbers, and I'd like to display the total of the numbers for each person? Thank you.

[@AndreaGarcia-rp1wy]

Any answer to this question.

[@AjaykrishnaRA]

So after the power query window has opened for the first time. Click on the Books Read column heading. It would choose the entire column. In the home tab, right in the middle of the ribbon, there would be an option named "Data Type: Number". Click on it and a drop down will be opened. Choose 'Text' from the drop down. And then follow whatever the video says. It should work.

[@cesarvillegas3531]

Once loading into Power query, go to the syntax and change the integer type “Int64.Type” to “type text” like the other fields. You should be good to continue.

[@vidsbyme2590]

How do we combine rows of information (row a has multiple names some repeating), like you just did, but have the information pulled to another column rather than combine the two? I am looking at a sheet that has multiple rows of the same name but different numbers in each column (column b, c,d etc). I am using mail merge to send out payment reminders but I don't want to have multiple reminders for each payment, would like to have the ability to bull from column a, b, c if they have the same name in column A to c,e,f column. john doe(row 1), $xxxx (column b) $xxx (column c) john doe (row 2), $xoxoxo (column b), $oyoyoy (column c) I want to move row 2 (because it is the same name), column b & C up to column D & E row 1. I have hundreds of rows some have two or more duplicate names.

[@PFunk-kt9gc]

Can this be done using VBA? I would like to combine duplicates in column A and SUM corresponding values in column similar to using the CONSOLIDATION option in Excel.

[@jungyoogeun12]

thank you so much! i made it

[@onbeingattached]

Thank you. How do you remove duplicate data that shows up like "X, X, X"

[@drenfreezy6614]

Is there a way to do this where each book read drops into a separate column/cell rather than listing all books in one cell? For example, Book 1 column, Book 2 column, etc.

[@OferiaFirchaYenisSaputri]

thank you, it's help me a lot

[@manishapanda9988]

I have value in different column how to do it

[@anthonynaughgle3616]

I keep getting "FALSE, FALSE, FALSE..." any chance you have an idea what I may be doing wrong, my formula is identical (names swapped) as far as I can tell.

[@iamteeten]

Hi sir need your help badly....

[@catecce3028]

Thanks

[@arrianranger5800]

This looks like just what I want but the processes and terminology are way over my head. Isn't there a more simple way of doing that. TOOO TOOOO many steps