Sylvia has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course
Excel 2010
I am trying to copy some data from one worksheet to another. On the first worksheet the data has been entered in one column ( vertical). I need to copy the data so that it is in rows ( horizontal). I am trying to set up the = function, and go to the corresponding cell in the worksheet. It works. I now have : a formula : ='EROFL Net Performance'!F14. I would like to copy this through horizontally, but so that the next cell is ='EROFL Net Performance'!F15 . This doesn't work, because I get ='EROFL Net Performance'!G15. What should I do to make sure that I get one cell down, but always F instead of moving over by one column? ( G, E, etc...?). I hope this is clear...? Thank you very much.
Best regards. Sylvie
RE: Excel 2010
Hi Sylvia, thanks for your query. What you are trying to do is called transposition and there is a function to do that for you in Excel:
http://www.dummies.com/how-to/content/moving-excel-2010-data-from-rows-to-columns-and-ba.html
Hope this helps,
Anthony
