Consolidate Data in Excel that has Multiple Duplicate Values On the Same Excel Worksheet

[@TeachExcel]

VBA/Macros Course (40% Discount): www.teachexcel.com/vba-course-update.php?src=youtube_v_description_pinned_comment_IGaq_biQ1B8

[@merlin8675309]

10 years later and this is the only video I found that shows EXACTLY what I knew could be done in excel to solve my issue. Thanks!

[@TianchiMa-yj5zt]

What did you do in the past 14 years then...

[@yubrajghimire7]

13 years and still relevant, Thank you.

[@TeachExcel]

You're welcome Yubraj! :)

[@saadansari4041]

I am watching this 2024 and this helped me a lot.

[@CherryGummy-kk6li]

Wonderful video! Clear and straight to the point. We're in 2024, and your explanation is still very valuable. Thank you! 🤩

[@iPYW]

My man, I've been looking all day for this and even Chat GPT didn't understand what I needed.

[@tomtainter8604]

Great example! Exactly what I was looking for. Very well illustrated and "CLEARLY SPOKEN" also. Too many examples (youtube & other places) are by "people" who fail to realize that the viewer needs to HEAR (clearly spoken words, not mumbled), SEE (readable, well displayed examples), and TIME (enough time to absorb a new concept). Yours did that well! Many Thanks.

[@TeachExcel]

Thank you so much for your kind and considerate words, I'm really glad you like my tutorial! :)

[@klncgty]

YOU ARE MAN!! this is what ı am searching for 4 hours

[@subratgfor3379]

After 12 year i show your video 👍👍👍👍

[@aatmarthjibu6756]

*saw?

[@grantwillcott2668]

thank you I have been looking for this for the last 2 days.

[@pnew1537]

Just wanted to give a BIG THANKS! Visited several other sites but until landing here, could not get it to work.

[@Sufyan45699]

It's really helpful to me 🙂

[@robertknobelsdorf4903]

as someone wrote in the comment section before - this is first video about what I really wanted to do, thanks sir! if anyone wonders - it works the same in excel version 2022 (office 365)

[@thewanderingone679]

Even to this day this tutorial was short and sweet. Thanks!

[@zakareyaghallab4256]

14 Years and still valid . Thanks !

[@Falcon-if4cs]

This is old more than 10 years, but still it is helpful. Thanks a lot Sir.

[@marimartin12]

How to cosolidate if I have duplicate values which are "text"

[@SpeakLifeNotDeath]

Thank you for your help. Wow, this will save me so much time :) very grateful

[@yogeshsalunkhe494]

Thanks for resolving my panic when I was watching this video. It helps me to sort the data in simple way in excel i also don't know this command

[@ranjitmaniktala826]

I liked it. It's just a 3-step process. I got it what I wanted. Thanx a ton...

[@darkmana1000]

Thanks, this is the only tutorial that worked.

[@solidthoughtpoker5207]

THANK YOU. You saved me hours of my life

[@jovipk1]

Thanks for sharing this great video, I was looking this solution in Pivot table but had no luck, but this lesson really helps me.

[@PitaaaBby]

Only video that helped me!! Thanks!

[@puravthakur2897]

Thank you so much sir. I m from India and you make me understand this command so thank you so much ❤️🥰🥰 once again sir

[@afolabiabioye6482]

This tutorial just make life better for me. Thanks for this video, i will like to learn more, kindly suggest more functions to learn

[@TeachExcel]

I am so happy to hear this :) Which to learn next? Wow, there are sooooooo many. Here is a recent one that I did that touches on multiple topics, including useful formulas, to create a nice interface for viewing data for specific time periods: kzbin.info/www/bejne/npuZe4aJhq6lmtk You can also check out my playlist here that is for shorter helpful excel tutorials that are easy to digest: kzbin.info/aero/PLxhsXZXQXrUBRG1QskvchMBezTR9ZTWaj

[@ja1751]

After watching 100 of video you solved my problem

[@vailedcarrot]

12 years on and still helping thank you so much

[@Ryanrenata01]

thanks for saving my life brother

[@amolchaturvedi2151]

13 years later still helpful..

[@SayidahNafisah]

2022 and ur video solve my problem. Tq so much!

[@gauravkotkar3731]

Looking for such simple consolidating,thanks for this...

[@NeutronStar9]

Thank you, you saved my day in 2022

[@juliz2]

Great job man, clear and fast at the point, I like it

[@deepapadiyar59]

Thank you...this trick helped me a lot... 🙏

[@opbankolia]

Thanks a lot from IIT Kanpur............You saved me....

[@rubelbabu1670]

Thanks for share this nice trick,,very helpful for me

[@muhammadayaz8071]

Very useful thanks sir

[@Kim_Mittenz]

NEEDED THIS!!! Thank you!

[@matthewoconnor5975]

This video is 13 years old and still helping me for a college research project lol

[@royidubor2462]

THANK YOU SO MUCH FOR THIS VIDEO, THE NAME ON TABLE ARE NO LONGER SHOW, HELP TO RESOLVE THIS

[@peixunzhou8540]

Nice video, it helped me with data analysis!

[@nnannachijioke5917]

Thanks for the video it nailed the topic

[@nathanaelurban9071]

I'm sure that I'm one of many to say this but THANK YOU! You've saved my ass at the 11th hour.

[@kingbrouwer1534]

nice and simple, thanks! Was looking for this solution but couldnt find it. great work

[@nicolecosta4142]

Thank you! A life saver!

[@mwelumichael3542]

God bless you :)

[@taimurbaig9411]

Thanks mate... extremely helpful.!

[@dipenvarmora]

Thanks brother you saved my life 😄😁

[@dipenvarmora]

Exactly this is what I was looking for!

[@dipenvarmora]

My friends are highly educated and studying in kings university but then also they don’t this simple thing

[@githinmathew2529]

just what i was looking for.

[@vincegadget8509]

thank a lot, you save me a week of task

[@Tree_Expert]

Brilliant. This really helped. Love the speed, as i was able to follow along

[@alyazulaikha372]

THANKS SO MUCH FOR THIS VIDEO!! i keep get error "source overlaps destination area". Now I already know why. Thanks so much

[@Kiruva_]

Oh god thank u bro❤❤❤ my problem is solved it was 50,000 data.😊

[@charlie_the_unicorn]

Thank you sooo much for this, this really helped me out massively at work!

[@TeachExcel]

I'm very glad to hear that :)))

[@Namsu11]

Thank you for this video! Very helpful and you explained it very simply

[@ashokbhum06]

Hi.. Great video.. Any idea if there are multiple rows of same value and if we need to display and consolidate it

[@tnamnatmnaw7544]

Hi! thanks for providing a very simple and easy way to do this. I have a huge data and this helps a lot. thanks!

[@urakih39]

Omg, thank you so much for posting this video. Took me hours to find a perfect example but it was worth the trouble after watching this. Your Awesome!!

[@dontjudgeme58]

This helped me with my college assignment. Thanks a lot!

[@salmanhasan9758]

Very well explained. Much appreciated.

[@yuema1495]

Short and simple ! Exactly what I need !!!!

[@ChristopherBabson]

Excellent. Thanks. I had a hard time finding a solution to this, relatively easy, issue, yet it was hard to find a solution at all, much less one that was clearly explained. THANKS.

[@mohammadnowshad1308]

It's work. Thank you so much!!!!

[@alaaalayoub4345]

you are the best in explain really thank you so much, God bless you

[@JamesSmith-bo3po]

First of al thanks for this tutorial. How can I integrate or add a unique ID to each person on the list?

[@vasuchawla2430]

helped me at work lol, very nice

[@ashokudla]

Thank you for explaining in right way..

[@aaronheller2836]

Teach excell, What it there is another column to the left of the names column, but I still want to merge by name. What would I click instead of clicking "left column" in the use labels option? My scenerio: My left column is the name of the product, my middle column is the product number, and my right column is the price of the items.

[@sturdydoors1446]

Thank you very much. Very informative and helped me a lot for my business accounting.

[@sumitbilochi8509]

It was a great help and complete time saver. Thanks a ton.

[@stevehinkel8185]

Very useful. Thank you!

[@AnamikaSharma-ug4tn]

Thanks for the video sir

[@NIK-to3xs]

Wow...awesome ...damn why did not i see ur video earlier 🥲🙏

[@estephanina]

@teachexcel do you know how i can do this Consolidate command in Power Query?

[@JenniferJones-x9d]

Thanks for this.

[@guidrydale]

This was very helpful. Thank you for sharing your knowledge

[@merck123able]

Perfect. Easy to follow.

[@a1-team-9z27]

waw, that's great explanation

[@samehkamel7141]

Thank you so much, that tut saved my time big time

[@maikolzakalak9192]

WOWWWW BEST VIDEO EVER

[@jaydeeeable]

Great video... Thank you!!

[@vijaymalviya9096]

I am very happy to get it thank you very much sir

[@kurkgang275]

Thanks, it is really helpfull

[@userme2803]

thanks for your video. Can you show us how you can do it from multiple files as you said? thank you

[@arrowtaps9910]

Brilliant Thank you.

[@aaronreece13]

This helped me a ton. Thank you!

[@rluxon]

this helps a lot, but what if we have other columns that also need to be transferred? for example, I have an sales sheet with part numbers, quantity sold, cost and list price. I want to consolidate all my sales from the past year but keep the part number, cost and list the same. how can I do this?

[@MatthewSmith-zs2jl]

I can't find the workbook on the website. Can somebody provide a link?

[@rexbk]

Awesome! Thanks

[@aungmyinthtwe6305]

Thank you!It's very useful formula

[@Mr.DeJean_3516]

Thank you! Save my life

[@dryrotdryrot9908]

This is fine, but it is not using VBA. If I have a weekly report I wish to automate, and the number of rows is different each time, what would be the code to always select , say, R2C2:R(last row)C3?

[@ProdigyJay]

This was SOOOOOOOO helpful!! Thank you so much for this video!!! Man, I was stuck and you got me out of it..... Thank you, thank you, thank you!!!! :)

[@TeachExcel]

Glad to help :)

[@katibtechgamer8635]

Great guy 😉🤠

[@JunkFoodPapas]

Thanks for the video. For some reason I am not getting a sum for my numbers.

[@subbuangrau2945]

Excellent 😊😊😊

[@musicaangomera]

Why are all examples in excel allways done with numbers, what if you have text in front of the names, how do you consolidate that?

[@MaximumGameplayCanada]

God bless you man , you and the guy who created Excel LOL

[@Honeyko1026]

Help. How about if there is another column for another data? Will it follow the command in consolidating?