Posted to microsoft.public.excel.misc

Gordon[_3_] Gordon[_3_] is offline

external usenet poster

Posts: 3

Transpose function

Excel can do transposition from Row to Column and vise versa. Can it
transpose from Row to Sheet?

E.g. from:
Sheet1 A1 10
Sheet1 A2 11
Sheet1 A3 12

to

Sheet2 B1 10
Sheet3 B1 11
Sheet4 B1 12

I use Excel 2003.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Transpose Function	mario	Excel Worksheet Functions	1	December 28th 06 06:50 PM
Transpose Function?	rollinn95z	Excel Worksheet Functions	5	May 27th 06 05:51 PM
Transpose Function	EMCUE	Excel Worksheet Functions	3	April 8th 06 01:44 AM
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES	Umair Aslam	Excel Worksheet Functions	1	September 22nd 05 01:19 PM
How do I use the Transpose Function	Tanweer	Excel Worksheet Functions	2	June 13th 05 06:11 PM

All times are GMT +1. The time now is 02:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us