And X so you can quickly add subtitles on your database based on any different than major.
So if you look at my shoot here.
What makes more sense.
Basically the bird the brand.
So you will like do you will like to find the sum total for each of the separate brands to apply substitutions
you will click here on this checkout we're done here and click subtotal on your right hand.
And now I'm sort of asking you next will you need to last up to those.
First of all at each change in yes.
Make sure that we are selecting the bird brand here.
Nike is what you want to do you want to downplay you want to some I want for some and what some do you
want to which is which column do you want to offer the for.
So I will take the word for full price and of course both of them and I will click Okay.
We will see that Excel has added the subgroup for each of these brand retail price and across the board.
This one says I can brand and it has that had added separately so both of two columns.
This way you can quickly add some glucose to any of the column we want based on any parameter.
This is one of the favorite tools and Microsoft Excel.
And if you live here you can also hide and you can spend any of the figure that you want to see.
So for example if we want to hide and make them up in the queue and it has to be how good my am I can
then get up.
It is only showing me that Google would take you on this list.
Let's put them here.
It was pretty sure you all the lines as well.