Need some help at work! EXCEL!

[Fingolfin269]

I just had some data emailed to me that's in a pretty lame form. Basically all of the information is running horizontally and I need it to be vertical. The thing is, all the information underneath the columns needs to be flipped along with it, for example :

A B C D E F G
A1 B1 C1 D1 E1 F1 G1
A2 B2 C2 D2 E2 F2 G2
... etc

I need it to run like this :

A A1 A2
B B1 B2
C C1 C2

etc.

Thanks for any help!

 

[AmitPatel]

Select the stuff... new sheet... paste special... transpose!-

 

[DeviousTrap]

Originally posted by: AmitPatel
Select the stuff... new sheet... paste special... transpose!-

Yup... you beat me to it 😛

 

[Fingolfin269]

Well, that will come in handy in the future! Thanks!

 

[Electric Amish]

Originally posted by: AmitPatel
Select the stuff... new sheet... paste special... transpose!-

GODDAMNSONOFABITCHMOTHERFVCKINPIECEOFSH!T!!!!


WHERE WERE YOU 4 MONTHS AGO!!!!

:|:|:|

 

[Ilmater]

Originally posted by: Electric Amish

Originally posted by: AmitPatel
Select the stuff... new sheet... paste special... transpose!-

GODDAMNSONOFABITCHMOTHERFVCKINPIECEOFSH!T!!!!


WHERE WERE YOU 4 MONTHS AGO!!!!

:|:|:|

Ask and you shall receive! I think there are enough people on here that consider themselves Excel GODS (myself included) that you should be able to find someone that knows this stuff.

 

[AmitPatel]

hahaha... 4 months ago forums.anandtech.com was on my company's banned list of websites... but somehow it got unblocked recently... stupid SmartFilter crap...

and I forgot "copy"

Select the stuff... copy... new sheet... paste special... transpose!

 

[Fingolfin269]

TRANSPOSE TRANSPOSE

That was all you had to say. 😉