antnee Posted January 31, 2007 Share Posted January 31, 2007 ive got data organised in coloums but i want it in rows instead, is there an easy ways of turning it around? eg title 1 2 3 4 5 title2 1 2 3 4 5 title3 1 2 3 4 5 but i want it title Title2 1 1 2 2 3 3 4 4 5 5 if you get what mean Quote Link to comment Share on other sites More sharing options...
sea118 Posted January 31, 2007 Share Posted January 31, 2007 you mean you have it in rows but you want it in columns? so like the numbers are going down instead of accross, below each title? id say copy and paste to another few squares, then delete the area you dont need then copy and paste them back putting them into the right squares though. unless you have formulas in each of the box's then i dont have a clue and itll be quite hard/awkward id expect. Quote Link to comment Share on other sites More sharing options...
Ziggy122 Posted February 1, 2007 Share Posted February 1, 2007 just highlight and drag and drop i h8 excel... esp doing VLookup for my IT coursework... Ziggy Quote Link to comment Share on other sites More sharing options...
koroshko Posted February 1, 2007 Share Posted February 1, 2007 dont dis exel can in handly last night i couldnt be bothered working out the answers to round 20 different sets of results for my physics so quick equation and done in seconds Quote Link to comment Share on other sites More sharing options...
antnee Posted February 1, 2007 Author Share Posted February 1, 2007 sorted it now, teacher told me how Quote Link to comment Share on other sites More sharing options...
antnee Posted February 4, 2007 Author Share Posted February 4, 2007 does anyone know how to make text go the proper way not like this Quote Link to comment Share on other sites More sharing options...
edbond Posted February 6, 2007 Share Posted February 6, 2007 does anyone know how to make text go the proper way not like this Hightlight the text and either press ctrl+1 or click format then cells click alignnment and move the dial on the Orientation box to horizontal. Rgds Ed Quote Link to comment Share on other sites More sharing options...
edbond Posted February 6, 2007 Share Posted February 6, 2007 ive got data organised in coloums but i want it in rows instead, is there an easy ways of turning it around? eg title 1 2 3 4 5 title2 1 2 3 4 5 title3 1 2 3 4 5 but i want it title Title2 1 1 2 2 3 3 4 4 5 5 if you get what mean In case anyone else wants to know, copy the text, Move the pointed to where u want to paste the information, (make sure only 1 cell is highlighted) then click edit - paste special and then check the transpose option done! Ed Quote Link to comment Share on other sites More sharing options...
antnee Posted February 6, 2007 Author Share Posted February 6, 2007 forgot about this topic prob :@ so how the writing is, how do you get it to change to normal? Quote Link to comment Share on other sites More sharing options...
Sin Posted February 6, 2007 Share Posted February 6, 2007 i h8 excel... esp doing VLookup for my IT coursework... Ziggy we've just started on Vlookup, dont see too bad.... Quote Link to comment Share on other sites More sharing options...
jaf1968 Posted February 8, 2007 Share Posted February 8, 2007 Count how many spaces you got between the letters. Highlight the cells. Go to edit -> replace. In the 'find what' box enter the number of spaces you have. Leave the 'replace with' blank and hit 'replace all' Quote Link to comment Share on other sites More sharing options...
antnee Posted February 8, 2007 Author Share Posted February 8, 2007 sorted it now it was something to do with the justification Quote Link to comment Share on other sites More sharing options...
edbond Posted February 8, 2007 Share Posted February 8, 2007 Try playing with vlookups embedded with H lookups they are fun..... or my personnel favourite, identifying duplicates in a column using a recursive count function. Ed (professional excel nerd - pays the mortgage so can't complain!) Quote Link to comment Share on other sites More sharing options...
jaf1968 Posted February 8, 2007 Share Posted February 8, 2007 Or it could be something to do with the justification Quote Link to comment Share on other sites More sharing options...
chris_dono Posted February 8, 2007 Share Posted February 8, 2007 looks like it's formatted as double spaced to me try CTRL + 1 (format cells) and check it out Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.