New Posts For Thread: Pivot Table helphttps://community.betfair.com/general_betting/go/thread/view/94082/26476425/pivot-table-helpHello.I've created a pivot table just to display the away teams played by the home team - the score and my ratings for both teams. However in some of the leagues Iam covering the teams play each other three or four times in a season.At the moment theThanks for that.I was inspired to make a work around based on CM's final suggestion.https://community.betfair.com/general_betting/go/thread/view/94082/26476425/pivot-table-help?post_id=478908777#478908777Thanks for that.I was inspired to make a work around based on CM's final suggestion.Tue, 21 Dec 2010 13:57:02 -0600Your first column of a table that you base your pivot table on needs to be unique values, so for the first columnit pays to have a sequence number.When you do your pivot table in the row data box, put that sequence header in first then directly belowhttps://community.betfair.com/general_betting/go/thread/view/94082/26476425/pivot-table-help?post_id=478493753#478493753Your first column of a table that you base your pivot table on needs to be unique values, so for the first columnit pays to have a sequence number.When you do your pivot table in the row data box, put that sequence header in first then directly belowSat, 18 Dec 2010 09:33:58 -0600*FWIW I'm terrible at excel so there's probably a one line answer.https://community.betfair.com/general_betting/go/thread/view/94082/26476425/pivot-table-help?post_id=478492773#478492773*FWIW I'm terrible at excel so there's probably a one line answer.Sat, 18 Dec 2010 09:23:46 -0600There may well be a way.... could you cheat it by1) Giving each match in your spreadsheet a match number (a2=a1+1 should be fine)then 2) Using the pivot report filter to give Home=Celtic, Away=Rangers3) Have the row labels as match number, so each mahttps://community.betfair.com/general_betting/go/thread/view/94082/26476425/pivot-table-help?post_id=478492733#478492733There may well be a way.... could you cheat it by1) Giving each match in your spreadsheet a match number (a2=a1+1 should be fine)then 2) Using the pivot report filter to give Home=Celtic, Away=Rangers3) Have the row labels as match number, so each maSat, 18 Dec 2010 09:23:24 -0600Hello.I've created a pivot table just to display the away teams played by the home team - the score and my ratings for both teams. However in some of the leagues Iam covering the teams play each other three or four times in a season.At the moment thehttps://community.betfair.com/general_betting/go/thread/view/94082/26476425/pivot-table-help?post_id=478485505#478485505Hello.I've created a pivot table just to display the away teams played by the home team - the score and my ratings for both teams. However in some of the leagues Iam covering the teams play each other three or four times in a season.At the moment theSat, 18 Dec 2010 08:15:29 -0600