Your Ad Here Your Ad Here
Results 1 to 7 of 7

Thread: Excel Word Help ....

  1. #1
    TRshady
    Guest
    Probably not what you wanna reply to on a monday morning .. but could someone please help! Am slowly going mad (more then I am now), with trying to make a column .. into a row. So I have this in excel for example:

    19
    28
    37
    46
    55
    69
    80

    But want it like:

    19 28 37 46 ... as a row ... any ideas?

  2. Lounge   -   #2
    100%'s Avatar ╚════╩═╬════╝
    Join Date
    Jan 2003
    Posts
    13,671
    Im not to good in Excel
    but
    why not simply write them in by hand?
    although im sure you can automate it.

  3. Lounge   -   #3
    TRshady
    Guest
    Thats the thing ... its over 100 numbers and was hard enough the first time round with getting everything mixed up. Theres 5 columns so Id much rather find a different way ..

    But have just done it with a column, lol.... simply copied and pasted and it turned out as a row, not column .. but cant find out how to do it again

  4. Lounge   -   #4
    bigboab's Avatar Poster BT Rep: +1
    Join Date
    Jul 2003
    Posts
    30,399
    Highlight your cells
    EDIT- COPY
    Select cell to copy to.
    EDIT - PASTE SPECIAL - TRANSPOSE - OK

    Hope that helps TR.
    The best way to keep a secret:- Tell everyone not to tell anyone.

  5. Lounge   -   #5
    TRshady
    Guest
    Yay! .... You are a perfect example of a great dude.
    Cheers Baobob ... has saved me 10mins of my live and a head of hear.

    I owe you one ....

  6. Lounge   -   #6
    TRshady
    Guest
    Ahhhhhhh ..... am still being driven mad by another related problem.
    Am making scatter charts to compare IQ against Hours of TV watched using a sample of 50.
    But cant work out how to do the bloody scatter graph!
    Get as far as selecting it .. but then am unsure of what goes where.

    Have data like this:

    IQ ............. Hours TV

    93 ............... 16
    116 .............. 10
    112 ............... 12

    For example ... so what goes where in the chart excel type input sheet?

    Really would appreciate the help here ....

  7. Lounge   -   #7
    brenda's Avatar Reborn again BT Rep: +3
    Join Date
    Mar 2004
    Posts
    1,509
    Originally posted by TRshady@22 March 2004 - 10:40
    Am making scatter charts to compare IQ against Hours of TV watched using a sample of 50.
    But cant work out how to do the bloody scatter graph!
    how many hours have you been watching TV for?
    This fate is worse than death. Condemned to live out existence in a vessel incapable of sustaining my true glory. How am I to function with such limitation? - Illyria

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •