New Posts For Thread: Excel Helphttps://community.betfair.com/chit_chat/go/thread/view/94038/30386365/excel-helpHere's the scenario; In a workbook I have a worksheet that has a vertical column with the results of Jan, Feb, March, which I update manually on a daily basis.To calculate averages, on another worksheet I have Jan, Feb, March on a horizontal. Each moscrap your second sheet, no point copy and pasting any data you already have.On the second sheet, insert pivot table and use that to calculate averages, days p/l, months p/l or whatever you want it to show.https://community.betfair.com/chit_chat/go/thread/view/94038/30386365/excel-help?post_id=542302835#542302835scrap your second sheet, no point copy and pasting any data you already have.On the second sheet, insert pivot table and use that to calculate averages, days p/l, months p/l or whatever you want it to show.Sun, 16 Nov 2014 12:16:41 -0600Bingo! You're a star Barry, that's exactly what I wanted. Thanks a lot! :)Hey Dude; About right mate! (spurs)https://community.betfair.com/chit_chat/go/thread/view/94038/30386365/excel-help?post_id=542301423#542301423Bingo! You're a star Barry, that's exactly what I wanted. Thanks a lot! :)Hey Dude; About right mate! (spurs)Sun, 16 Nov 2014 10:19:49 -0600nice to see Aspro backhttp://bit.ly/1xELkX7https://community.betfair.com/chit_chat/go/thread/view/94038/30386365/excel-help?post_id=542301281#542301281nice to see Aspro backhttp://bit.ly/1xELkX7Sun, 16 Nov 2014 10:07:13 -0600Try this:=INDEX(Sheet1!$A:$A,COLUMN(A:A))Put this formula in Cell A1 on Sheet 2. As you drag it accross it should transpose the vertical data on sheet 1 into horiszontal in sheet 2.https://community.betfair.com/chit_chat/go/thread/view/94038/30386365/excel-help?post_id=542301203#542301203Try this:=INDEX(Sheet1!$A:$A,COLUMN(A:A))Put this formula in Cell A1 on Sheet 2. As you drag it accross it should transpose the vertical data on sheet 1 into horiszontal in sheet 2.Sun, 16 Nov 2014 10:00:47 -0600OK, done that and it worked exactly as you said however; it doesn't solve my dilemma. Lets say I want to add an a11 and then for k1 I just want to copy and paste j1 to get the a11 automatically.. how do I do that?Thanks for the input, it is appreciathttps://community.betfair.com/chit_chat/go/thread/view/94038/30386365/excel-help?post_id=542300885#542300885OK, done that and it worked exactly as you said however; it doesn't solve my dilemma. Lets say I want to add an a11 and then for k1 I just want to copy and paste j1 to get the a11 automatically.. how do I do that?Thanks for the input, it is appreciatSun, 16 Nov 2014 09:34:43 -0600Say you have the data on Sheet 1 in A1:A10. You want it in Sheet 2 A1:J1. Select the range A1:J1 on sheet 2. A1 must be the active cell. In this cell type =TRANSPOSE(The go back to Sheet 1 and select range A1:A10. Then press and hold CTRL and SHIFT.https://community.betfair.com/chit_chat/go/thread/view/94038/30386365/excel-help?post_id=542298673#542298673Say you have the data on Sheet 1 in A1:A10. You want it in Sheet 2 A1:J1. Select the range A1:J1 on sheet 2. A1 must be the active cell. In this cell type =TRANSPOSE(The go back to Sheet 1 and select range A1:A10. Then press and hold CTRL and SHIFT.Sun, 16 Nov 2014 06:43:13 -0600I think you need to use the TRANSPOSE funciton of i am reading your question correctly. It is an array formula I believe so you would need to press CTRL+SHIFT+ENTER instead of just ENTER or it wont work. I wouldnt do this myself as there are better whttps://community.betfair.com/chit_chat/go/thread/view/94038/30386365/excel-help?post_id=542298589#542298589I think you need to use the TRANSPOSE funciton of i am reading your question correctly. It is an array formula I believe so you would need to press CTRL+SHIFT+ENTER instead of just ENTER or it wont work. I wouldnt do this myself as there are better wSun, 16 Nov 2014 06:34:51 -0600Here's the scenario; In a workbook I have a worksheet that has a vertical column with the results of Jan, Feb, March, which I update manually on a daily basis.To calculate averages, on another worksheet I have Jan, Feb, March on a horizontal. Each mohttps://community.betfair.com/chit_chat/go/thread/view/94038/30386365/excel-help?post_id=542298245#542298245Here's the scenario; In a workbook I have a worksheet that has a vertical column with the results of Jan, Feb, March, which I update manually on a daily basis.To calculate averages, on another worksheet I have Jan, Feb, March on a horizontal. Each moSun, 16 Nov 2014 05:54:18 -0600