Thank you Neil ! I appreciate the more slower pace and progressive instructions. Some say you could have done this in 2 minutes but I would have had to watch a few times before I got it so I actually appreciate that I could follow along with the video on one screen and the excel worksheet I was working on another. Thanks !!!
Neil, I have never commented on TH-cam before - but these instructions made me want to find out how to comment. I wanted to say thank you. I had no idea this feature existed, let alone how to use it! My two sheets are now merged, once I realised the two columns you link are the ones with the same data, not the column with the data to be merged. Thanks again for taking the trouble to help us, minions, out! It is appreciated.
Thank you, That was excellent! Although my office computer does not have a sound card, I was able to understand what exactly you are doing and then I repeated it by myself.
Thank you Neil, very useful video, I suggest people to have both spreadsheets in the same file and start watching at minute 4.10 up to minute 9.50 or. Very helpful again
Brilliant! I've been reading threads trying to figure out how to do this for quite some time. Some of the explanation parts were a bit long, but I just fast forwarded through the parts that were not useful for me.
Superb showing brother. I knew of this method way back when I took Access Database 2010. But to duplicate it in Excel was tough, even using variable lookup. This puts the icing on the cake. Thank you very much.
First, thank your for your video. It helped me work through the very same issues I was facing last night. Your video made it a very quick solution. Points to add in the next version: The order in which you add the fields is the order they will appear in the new worksheet. I was not able to order the fields the way I wanted them. Rats. Lastly, I say this only in jest:say it once and move on. ;-)
Thanks for your video, Neil! It totally helped me with some sheets I had to merge with hundreds of thousands of cells. As for some of the other comments about it being "hard to watch": I think that this video is great for folks of all different backgrounds. While its "painful to watch" to some more experienced persons, its can be valuable to persons starting to learn Office tricks.
I think this is great Neil! Thank you very much. And the detail helps too! Much much better than the MS Help nonsense that's not really clear. Thanks!!
I appreciate this video- however am hitting the wall around min. 7:30 with the actual merge. When I combine my data to include in my query I receive an error message- "Too few parameters. Expected 1." I have ALOT of parameters :( PLEASE HELP!
Neil... thanks so much for this. However, how can you run the query without loosing any data. E.g. (if we go by your example). If there is a Zip code that isn't listed in your long list of zip code. When you run the query Excel deletes that data... How can we prevent this??
I want to completely agree with Moufid Jazouli: this clip could have been done in about 2 or 3 minutes. Read the 1st comment of Isaac Madsen "I just fast forwarded through the parts that were not useful for me" (or better: for anyone) Neil, with a better preparation (e.g. a SCRIPT) for WHAT exactly you're going to explain and HOW you will show the key actions that are needed to understand the working of Excel merge, this clip would at least be much less enerving to follow. I think I can describe what viewers might feel: "Much cackling before the egg is laid" But of course, then there it is ;-)
Thanks Mr. Neil.... Its really wonderful and clear explanation. This will help me to resolve many queries and can share with my friends. Thanks again for sharing such a wonderful knowledge.
There are several Springfields in the US so they have different zip codes. but still have the same name. You didnt have to delete the doubles in the columns i dont think?
Note that this doesn't work on Excel for Mac without installing 3rd party software for OCDB drivers. Instead, it's easier to just upload your spreadsheet to Google Sheets and use the Merge Sheets add-on to merge sheets quickly and simply.
Hey! Just thought I would give you a big thanks for this tutorial... i was banging my head on my keyboard trying to merge datasets with vlookup, but you method works great. Cheers
Excel emerge files -Hello Neil I saw your video in youtube How To Merge Two Excel SpreadSheets Into One and I wanted some help implement the excell data files of YTZ(first site table ) and Popads(second site table) to find the profitable sites/countries ... I want something that we can daily put in website ID , country , revenue, expense, ROI and it will automatic ad the numbers to the right country/site and calculate if we make profit .. profit it turns in green. can you help me? Do you have ay video on that? thanks
Quick question - you say in the tutorial that both sheets need to have unique values in the zip column. So what happens if two of the people happen to live in the same zip code? Or does only one sheet (ie the sheet with zip and city) need to be unique?
You sound pretty hung over there , good job getting through it, I was feeling your pain but you got me through a-ok as always. Now time to tan that bevy!
Neil, I ran this tutorial once as a test and it worked like a charm! I tried running it again and it wont join the books. For my second test I used a larger data base, say 173 columns by 47 rows. is there anything i'm doing wrong? I would potentially like to do 173 columns by 2060 rows...
actually i am working in Administration section. i am pripare one worksheet total data willbe prepared. but i will be taken into another worksheet will be pripared i.e. 1st sheet data taken into different cells and posted into different rows. so that particular rows information transfer into antother worksheet in different cells. how to solve my probelm
So when I try this, one sheet has 8777 records, the other has 8351 but when I combine them I get 8312 records.. Why are some missing (yes the id number is unique so no duplicates) is there a limitation on size somewhere?
+Rudy Rodriguez Because that wouldn't tie 2 tables with different data together. If you have a sheet with "ID, Fruit Names", and another with "ID, People Names", and you want to combine them to see what fruit a person likes, copying & pasting won't work, you'd just get a mix of names & fruit. using this method it will use the ID field to combine the data so you end up with a new table with ID, Fuit Names, People Names
I'm dying man....I have some data to sort...I have phone numbers that have been validated and want to dedup the the files and remove the bad numbers and files from my master list......help Neil! chris
I am sorry to tell you that you seem talking to yourself. All your video can be achieved in maximum 2 minutes not more. I wonder why you keep repeating things like if you are talking to beginners. Watching your video makes me really upset and prefer not to watch it till the end. Sorry for that but not one will have the courage to tell you these true feelings. Sorry again and best regards
So , confusing and slowly -shorter is better . And you give too much information, which does not make the things easier, will be good if you make a short and clear video with no additional information
A really important and useful feature, but the explanation is hard to follow and boring. A long intro, and a bad end result (with two zip code columnes). :(
Been through so many examples that didnt work at all for me. This one actually worked, so thank you!
This link was incredibly helpful! I was looking at a 2+ day job. With this tip I turned it into a 2 hour job! Thanks Neil!
Helpful video. For all those who are complaining: Settings>Speed>1.5 or 2
Excellent video! Instructions were easy to follow and it does exactly what I needed to do!! Thank you!
I watched this with 1.5 speed and it was really useful. :) Thanks.
Thank you Neil ! I appreciate the more slower pace and progressive instructions. Some say you could have done this in 2 minutes but I would have had to watch a few times before I got it so I actually appreciate that I could follow along with the video on one screen and the excel worksheet I was working on another. Thanks !!!
Neil, I have never commented on TH-cam before - but these instructions made me want to find out how to comment.
I wanted to say thank you. I had no idea this feature existed, let alone how to use it!
My two sheets are now merged, once I realised the two columns you link are the ones with the same data, not the column with the data to be merged.
Thanks again for taking the trouble to help us, minions, out! It is appreciated.
Using Vlookup takes way less steps...
I did it, I did it! 6000 practice IDs and 22.5 regions from 23 different tables combined correctly! Thank you :)
You sir are a lifesaver. Could of been shorter but this was a great help!
Your video has helped me merge data and now am able to show my colleagues too. Thank you so much for your help!
Thank you so much! Your tutorial was easy to follow
Thank you, That was excellent! Although my office computer does not have a sound card, I was able to understand what exactly you are doing and then I repeated it by myself.
Thank you Neil. It is very helpful to me
Thank you. I was able to do this from your video however I agree it was super slow. Wondering if there is a way to see the 'unmatched" data.
Thanks, but not able to find the workbooks (6:31), after selecting data, after naming the two files and going to the third spreadsheet to merge them.
eveni have the same problem
aseem hegshetye same for me until I saved the workbooks to my H:/drive...smooth sailing after that.
Thank you Neil, very useful video, I suggest people to have both spreadsheets in the same file and start watching at minute 4.10 up to minute 9.50 or. Very helpful again
Neil. Thank you. This was very helpful!
Interesting way to merge data sets. I wonder if that query would slow down with large amounts of data the way v-lookups would.
Very helpful. All merge problems made easy.
Brilliant! I've been reading threads trying to figure out how to do this for quite some time. Some of the explanation parts were a bit long, but I just fast forwarded through the parts that were not useful for me.
Well done; I used to do this in MS Access... this is so much simpler.
Thank you.
Helped me with exactly what I needed! Thank you!
A+ Worked perfectly, and still works in Office 2016!
Super! Simple and clear instructions. Thank you, it saved me
Superb showing brother. I knew of this method way back when I took Access Database 2010. But to duplicate it in Excel was tough, even using variable lookup. This puts the icing on the cake. Thank you very much.
First, thank your for your video. It helped me work through the very same issues I was facing last night. Your video made it a very quick solution. Points to add in the next version: The order in which you add the fields is the order they will appear in the new worksheet. I was not able to order the fields the way I wanted them. Rats. Lastly, I say this only in jest:say it once and move on. ;-)
Thanks for your video, Neil! It totally helped me with some sheets I had to merge with hundreds of thousands of cells.
As for some of the other comments about it being "hard to watch": I think that this video is great for folks of all different backgrounds. While its "painful to watch" to some more experienced persons, its can be valuable to persons starting to learn Office tricks.
I think this is great Neil! Thank you very much. And the detail helps too! Much much better than the MS Help nonsense that's not really clear. Thanks!!
Thanks so much, this was very helpful!
Painful to watch. Just get to the point.
rsissel1 No Shit
yes just get to the point
really
Is it possible to create the combined data sheet and include the rows that didn't have a match from both columns?
I appreciate this video- however am hitting the wall around min. 7:30 with the actual merge. When I combine my data to include in my query I receive an error message- "Too few parameters. Expected 1." I have ALOT of parameters :( PLEASE HELP!
Great tutorial, appreciate the time and effort you spent to make this, you saved me a lot of time and frustration!
Thank you but painful to watch. Could be stated in 2 minutes. Just give the directions and move on. There's so much added fluff
agreed. i'm 4 minutes in and he hasn't done anything yet
Dear lord this is painful
thats why you watch it in 2 times speed
Neil... thanks so much for this. However, how can you run the query without loosing any data. E.g. (if we go by your example). If there is a Zip code that isn't listed in your long list of zip code. When you run the query Excel deletes that data... How can we prevent this??
This was perfect, worth my time and solved my problem.
I want to completely agree with Moufid Jazouli: this clip could have been done in about 2 or 3 minutes. Read the 1st comment of Isaac Madsen "I just fast forwarded through the parts that were not useful for me" (or better: for anyone)
Neil, with a better preparation (e.g. a SCRIPT) for WHAT exactly you're going to explain and HOW you will show the key actions that are needed to understand the working of Excel merge, this clip would at least be much less enerving to follow.
I think I can describe what viewers might feel: "Much cackling before the egg is laid"
But of course, then there it is ;-)
Thanks Mr. Neil.... Its really wonderful and clear explanation. This will help me to resolve many queries and can share with my friends. Thanks again for sharing such a wonderful knowledge.
There are several Springfields in the US so they have different zip codes. but still have the same name. You didnt have to delete the doubles in the columns i dont think?
Note that this doesn't work on Excel for Mac without installing 3rd party software for OCDB drivers. Instead, it's easier to just upload your spreadsheet to Google Sheets and use the Merge Sheets add-on to merge sheets quickly and simply.
Thanks just the refresher I needed
Hey! Just thought I would give you a big thanks for this tutorial... i was banging my head on my keyboard trying to merge datasets with vlookup, but you method works great. Cheers
Thank you very much dude.... Helped a lot...
Neil, very helpful and much appreciated. The folks with the negative comments can piss up a rope.
Excel emerge files -Hello Neil I saw your video in youtube How To Merge Two Excel SpreadSheets Into One and I wanted some help
implement the excell data files of YTZ(first site table ) and Popads(second site table) to find the profitable sites/countries ... I want something that we can daily put in website ID , country , revenue, expense, ROI and it will automatic ad the numbers to the right country/site and calculate if we make profit .. profit it turns in green.
can you help me? Do you have ay video on that?
thanks
Quick question - you say in the tutorial that both sheets need to have unique values in the zip column. So what happens if two of the people happen to live in the same zip code? Or does only one sheet (ie the sheet with zip and city) need to be unique?
You sound pretty hung over there , good job getting through it, I was feeling your pain but you got me through a-ok as always. Now time to tan that bevy!
Neil, I ran this tutorial once as a test and it worked like a charm! I tried running it again and it wont join the books. For my second test I used a larger data base, say 173 columns by 47 rows. is there anything i'm doing wrong? I would potentially like to do 173 columns by 2060 rows...
Very helpful, thank you!
Great video. Thank You!!!!
Like is a lot... however the data I am trying to combine is very different to your demonstrated... however, I will it give it a try and see it goes.
This was helpful, but could have been explained faster. Thanks!
Saved my bacon, thank you!
Excellent - saved me some time :)
actually i am working in Administration section. i am pripare one worksheet total data willbe prepared. but i will be taken into another worksheet will be pripared i.e. 1st sheet data taken into different cells and posted into different rows. so that particular rows information transfer into antother worksheet in different cells. how to solve my probelm
Thanks Neil.
When I tried this I get an error "data source contains no visible tables". Any idea what's going on?
Were you able to figure out what was wrong?
It was of great help to me! you saved me
Thanks a lot for your effort!
Thanks Neil, there's some great stuff in here but try to make your next vids a bit shorter mate, many thx though!!
Magic! Thank you
thank you for your time..
Fantastic. Mr. Jazouli! For you it might take 2 minutes. Then please upload your video!
thanks and i save lots of time..
this works new office editions also 'Office 2016'
Improper explanation.What task you performing not clearly visible...
Thank you! :D
Exactly. I agree with previous comment !
Thanks a lot don't mind the unappreciative people.
How to join two workbooks from two separate excel files?
4:16 is where it starts.
How to Transfor Data One worksheet in different cells transfer to another work sheet
Thanks so much.
So when I try this, one sheet has 8777 records, the other has 8351 but when I combine them I get 8312 records.. Why are some missing (yes the id number is unique so no duplicates) is there a limitation on size somewhere?
cz only the record which find a match i.e. the common records will b listed
THANK YOU!
omg. you talk too much just go straight to the point.
Thank you :)
WHAT IS WRONG WITH DOING A COPY AND PASTE OF THE RECORDS OF ONE EXCEL FILE TO ANOTHER EXCEL FILE AND THEN GETTING RID OF ANY DUPLICATE RECORDS ?
+Rudy Rodriguez Because that wouldn't tie 2 tables with different data together. If you have a sheet with "ID, Fruit Names", and another with "ID, People Names", and you want to combine them to see what fruit a person likes, copying & pasting won't work, you'd just get a mix of names & fruit. using this method it will use the ID field to combine the data so you end up with a new table with ID, Fuit Names, People Names
I'm dying man....I have some data to sort...I have phone numbers that have been validated and want to dedup the the files and remove the bad numbers and files from my master list......help Neil!
chris
Helpful video but unclear on some important steps so that lessens the value. But thanks for the effort.
if you rename the Excel or move to a different folder or machine this will fail.
Thanks
how it is different from Vlook
YOU ARE DRIVING ME NUTS!!!! Get on with it!!!
I am sorry to tell you that you seem talking to yourself. All your video can be achieved in maximum 2 minutes not more. I wonder why you keep repeating things like if you are talking to beginners. Watching your video makes me really upset and prefer not to watch it till the end. Sorry for that but not one will have the courage to tell you these true feelings. Sorry again and best regards
You speak to much, Bla bla bla. But good job.
DOES NOT WORK ON MAC.
For the first 4 minutes of the video, he goes around explaining the same thing over and over again... boring, get to the point!
So , confusing and slowly -shorter is better . And you give too much information, which does not make the things easier, will be good if you make a short and clear video with no additional information
A really important and useful feature, but the explanation is hard to follow and boring. A long intro, and a bad end result (with two zip code columnes). :(
13mins?????
Is this video really 12 minutes long? Reconsider what's important to you mate, people don't have that kind of time.
Fell asleep!
Agreed ... painful to watch.
Neil ... You talk too much.
Thanks, but no thanks.
Holy crap get to the dang point geeeez!
cut the talking and show us how to do it...GEEZ!
It is pain to watch! You could have told the same in 2 minutes. I've got nervous after this tutorial!
man just get to the point
12 minutes, wtf?
you talk too much, talk to the point
Neil Ball? More like No balls
Well ya cant work with no balls
you are irritating, thing you can explain in two minutes, you took long time. even you are not sure what you are saying. lol