Excel Word Help ....

[TRshady]

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?

[100%]

Im not to good in Excel
but
why not simply write them in by hand?
although im sure you can automate it.

[TRshady]

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

[bigboab]

Highlight your cells
EDIT- COPY
Select cell to copy to.
EDIT - PASTE SPECIAL - TRANSPOSE - OK

Hope that helps TR.

[TRshady]

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 ....

[TRshady]

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 ....

[brenda]

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?