 Then I'm going to go into the data up top and then we'll go into the data tools and the text two columns and Then once again Deliminated by the commas next and I want it comma-deliminated looks good. It looks like it's doing what we want down here next and Okay general. Okay finish it. Let's make the top bit bold So that we can then hopefully Excel will know that that's the header home tab font group bolden and then I'm going to put my cursor somewhere in the data and Go to the insert tab and I'm going to be picking up the table and the table here so let's insert the table and Boom so now we've got our two data sets for 1920 and 2000 I'm going to insert another one more Row above it insert so I can say this was 2022 Data and let's do that up here too. Just so I can make sure I know which data is which Which is which? insert And I'll say this was 1920 those are the two years we did am I right am I right? Okay? I think so, okay? So there's our data. So now what I'd like to do is just get the batting averages Over so I want to pick up the batting so I'd like to get the player's name as well possibly So do I need their age or any of this other stuff? No, let's just get the batting average. So I'm gonna I'm gonna put my cursor from C and I'm gonna scroll over now You possibly might do this with pivot tables as well, but I'm just gonna do the good old normal table I'm gonna right-click and hide So now we've got our batting averages now when we sort the batting averages I'm gonna make column B a little bit wider so we could see the players names Notice that we might have like some outliers With the batting averages So if I if I drop it down and go from z to a all these zeros in the batting average when you're looking at the actual data sets then You know that that might not be applicable, right? You might you might not want the zeros and the batting averages because it might that might be indicating that these people Didn't have any at bats or anything like that, right? So maybe we trim off the zeros and On the high side as well You could say well one Or a hundred percent Possibly that's because they had a very low at bats. They might not have that many at bats So this these are kind of skewing our data You know if they had like if they had one at bat and they got it so oftentimes we might say Maybe it would be better for me to trim off the extreme numbers And so I can filter by hitting the drop-down and say maybe I should trim off all of the zeros Maybe I'll keep everything else and maybe I trim off like the 100s and anything that's a blank that doesn't have anything in it then I want to remove those as well So so I'll trim down my data to that Thinking that maybe that's a more a better representation You know of the people in in the data set So now notice what happened is it hid some rows because I filtered I filtered those out So it goes from two to six That's why I don't want to have anything to the right of my data set because if I have this filtered It's gonna it's gonna squish up all of all of the stuff I do to the right because it removed these rows That's why I'd rather copy this information Now that it's filtered and paste what I want to deal with in another tab So I'm gonna open up another tab. I'm gonna double-click on it. I'm gonna call it blank To or let's call this one blank data. This is the blank data. It's not blank data But it's the data for our blank worksheet and then I'm gonna copy this I'll select these two and then I'll say control shift down. So it goes down to the bottom I'm gonna right-click and copy it and then go to my blank worksheet Paste it. I'm gonna hold control shift and scroll in a little bit in a one. I'm gonna place it just one two three Alright, so there we have it and then the top bit. I'm just gonna put in boldened home tab font and In boldened and then I'll put a table around this one After notice I removed those top bits like if I go to the last one you might think You might think hey, maybe it's still pulled in those ones But it didn't because like if I copy this control C and you look at the dancing ants and I unfilter And I say remove the filters Or select all actually hearty. That's not where the filter was Remove the filters. You can see the dancing ants are not around these ones because we filtered them out So the filtered ones are not included here. So now I'm gonna insert a table insert table and then I'm gonna say okay and Then batting average. This is for 1920 Let's say so there we have it names a little bit larger Let's do the same thing for the 2022 control shift down and so now I want to pick up the 2022. There's my batting averages I'll do the same thing I don't want these blank numbers and I don't want the zeros and I don't want the hundreds because those are probably skewed Stats possibly because of the number of at bats or whatever it so here's like this one even has a point four that's you know, pretty low, you know, maybe we remove the point oh four and the point oh five and I'll keep the ones after that and then I'll go down to the bottom and This one goes up to point seven five. Let's get rid of the blanks point seven fives pretty out there. It's probably probably Probably one person that didn't have that many at bats, but I'll keep it and we'll say okay So then I'm gonna copy these two control shift down and Then control C copy. I'm gonna put this on the blank tab and we'll put it up here in D One right-click and paste it just one two three Select in the top bit home tab font group data or Bold and then I'm gonna put my cursor somewhere in the table and go into the insert Tables and put a table around it the dancing ants doing their table dance