how to make the data in this pivot table meaningful?

[bigdan]

I've downloaded my chess games into excel and trying to put them into a pivot table. At the moment I'm trying to analyze the games by opening but am stuck on how to make it meaningful.

This is what I'd want the result to look like. But I don't know how to do so.

Opening	Number of Games Played	Percentage of Games Played	Win Rate
King's Pawn	50	20%	45%
Sicilian	20	7%	47%

Here's the relevant part of the data. Something weird is happening in col X, not sure what that's about. The formula is consistent throughout the column. Let's ignore that for now.



nfq4

 

[Ezguy4u]

bigdan is there any way you can use XL2BB to display this worksheet?

XL2BB - Excel Range to BBCode

 

[bigdan]

not sure what purpose that would serve given that the screenshot is attached. however i'll attach an extract of the workbook

File Dropper - Online file sharing

Online file sharing

www.filedropper.com

 

[MARK858]

@bigdan, the purpose using XL2BB serves over an image is you can copy/paste the data into Excel (which you can't do with an image) rather than retype the whole data for testing.