How to Group the Data in Excel

Next Video:
How to Consolidate Values in Excel....5

Grouping the data in Excel requires you to have common data that you want to unite in the first place. Group the data 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 gonna show you how to group data in Excel. This is a very powerful thing that I use all the time. It's used when you have different cells that have something in common that you want to unite. So I have an example here. This is a made up chart of profits of a business, and as you can see, there's different kinds of animals here, and we're gonna, what we want to do is we want a header above the chickens and the ducks and the pigeons that we're gonna call poultry. So I'm gonna click on cells columns C through E here, and what you do is you select the cells that you want to unify, all at once, and then you look for a command called merge. It may be in a different place in a different menu depending on your computer and operating system, but it's always called merge. And we're just gonna click on it, and we're gonna say merge, and then we're gonna type in poultry, poultry. And we're gonna make it bold, and I also, and then we're gonna do the same thing over the cows, pigs and sheep. Now, let me show you another way to do it, is if you had, up here if you had livestock, and if you had livestock over each one, and you select them all, and you say merge, you're gonna get a warning that the selection contains multiple data values, and what, and it will merging into one cell will keep the upper-left most data only. That's okay, that's exactly what we want to do. So we say okay, and now it's all merged into a single cell that's actually over three different columns. So I hope this has been helpful. I'm Ted, and today I showed you how to group data in Excel. Thanks a lot for watching.


Related Searches

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