How to Consolidate Values in Excel

Next Video:
Adding Hours in Excel....5

Consolidating values in Excel is a really great way to make your information much easier to read. Consolidate values in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.

Part of the Video Series: Using Excel
Promoted By Zergnet


Video Transcript

Hi, I'm Ted. Today, I'm going to show you how to consolidate values in Excel. This is especially useful when you have a spreadsheet were you have a number of columns. And you wan to have a header that goes across a number of those columns or a number of rows. So, I've got a spreadsheet here, it's just a made sales list from an imaginary business. And her we have three columns, we've got chickens, ducks and pigeons. And we have three other columns, cows, pigs and sheep. And what we want to do is, we want to have this poultry label go across these three columns and the livestock value go across these three columns. So, the key is in, first select the first one with the first one where the text is and then, the other two. And then, go up and find the Merge function. It maybe in a different place on your computer, depending on your computer and your operating system. But it's always called Merge. And we'll just click Merge and there we have it. It combined all those three cells into one with the text consisting of the one that was on the left. Now, I'm going to do the same thing over here, but first I'm going to just say, what if we already had you know, some text in these two columns. What would happen? So, we're going to select all three of those and we're going to do the same thing, we'll say, Merge. And you can see, it gives you a message, it says, the selection contains multiple data values. It's preventing you from inadvertently writing over some text you didn't want to write over. But we're fine, we know that the value on the left which is the same as the other two, is the one we want. We say, O.K. and it does the same thing. It makes a new text field that goes over all three columns. We can do the same thing on the rows, over here we want to combine this title for the first quarter into, going across all of these rows. It just makes for a nicer looking table. We click on Merge and there it is. So, I hope this has been helpful. I'm Ted and today, I showed you how to consolidate values in Excel. Thanks for watching.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!