Change Columns to Rows

thing1 · Apr 25th, 2002, 07:52 AM

How can I take data that is in a column on one worksheet and change it to a row in another worksheet without having to retype it all.

Asala42 · Apr 25th, 2002, 07:56 AM

Easiest way would be a copy/paste special/traspose- are these formulas or values?

You could also use the TRANSPOSE Array formula: highlight the range you want the data (same number of cells) and type =TRANSPOSE(InitialRange) '--hit Ctrl+shift+enter to get the array.

Hope that helps,
Adam

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 07:52 AM	#1
thing1 New Member Join Date: Apr 2002 Posts: 1	How can I take data that is in a column on one worksheet and change it to a row in another worksheet without having to retype it all.

Apr 25th, 2002, 07:56 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	Easiest way would be a copy/paste special/traspose- are these formulas or values? You could also use the TRANSPOSE Array formula: highlight the range you want the data (same number of cells) and type =TRANSPOSE(InitialRange) '--hit Ctrl+shift+enter to get the array. Hope that helps, Adam