2d array transposing

jercook · May 16th, 2002, 07:44 AM

thanks, the problem was not stated quite right. The actual array is 960 rows long and 16 columns wide. Each new row that I want to produce will comprise 6 existing rows (with 96 cols) transposed and become a 96 rows x 160 cols transposed array. So, I need to take 6 rows and transpose them into 1 column until I fill the array with 160 cols. Can copy and transpose the rows- need help with inserting copied selection into next column.

[ This Message was edited by: jercook on 2002-05-16 07:12 ]

kkknie · May 16th, 2002, 07:48 AM

You can copy the range, then select paste special and check the transpose checkbox. You'll have to then delete the original since it doesn't work with cut (only copy).

K

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

May 16th, 2002, 07:44 AM	#1
jercook New Member Join Date: May 2002 Location: palm beach county Posts: 1	thanks, the problem was not stated quite right. The actual array is 960 rows long and 16 columns wide. Each new row that I want to produce will comprise 6 existing rows (with 96 cols) transposed and become a 96 rows x 160 cols transposed array. So, I need to take 6 rows and transpose them into 1 column until I fill the array with 160 cols. Can copy and transpose the rows- need help with inserting copied selection into next column. [ This Message was edited by: jercook on 2002-05-16 07:12 ]

May 16th, 2002, 07:48 AM	#2
kkknie Board Regular Join Date: Apr 2002 Location: Greenwood, SC Posts: 677	You can copy the range, then select paste special and check the transpose checkbox. You'll have to then delete the original since it doesn't work with cut (only copy). K