| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 89316 | 2008-04-27 10:19:00 | Excel 2000 data format change? | Billy T (70) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 663097 | 2008-04-27 10:19:00 | Hi Team I have just finished entering 800 data values into a spreadsheet and now find that I should have displayed the series indicators in a line across the top and the values in each series vertically in columns. I had a small amount of data like this once before and found a way to swap it around more or less automatically if I recall correctly, but for the life of me I can't remember how I did it or find the tool I used to do that. At present I have 80 lines and 10 columns instead of 10 lines and 80 columns! Any help would be appreciated. Cheers Billy 8-{) :groan: |
Billy T (70) | ||
| 663098 | 2008-04-27 10:50:00 | Hi Billy Select the area concerned, select menu option Edit > Copy, Edit > Paste Special > tick the 'Transpose' option > etc etc etc..... Andrew |
andrew93 (249) | ||
| 663099 | 2008-04-27 11:24:00 | Thank you Andrew, all done in the twinkling of an eye, and I can quit for the night with the promise of an easier start to the morning. Cheers Billy 8-{) :thanks |
Billy T (70) | ||
| 663100 | 2008-04-27 11:49:00 | Hi Billy Apologies for the etc etc etc part but I figured if I pointed you in the right direction then you would get the rest without me having to labour the point. Cheers Andrew |
andrew93 (249) | ||
| 1 | |||||