Sheeloo:

Thanks for your help. It does not matter. I'd like to copy something from
col V to AB (depend on value of Q, row 26----row 1000) and tranpose, paste at
row 26 col AZ, insert 2 Cells? maybe and continue to read from the table line
or row 27. Thanks.

"Sheeloo" wrote:

If you skip two rows from row 26 you would be on 29 (or 28 if you count 26
too) but not on 27...

Also if you are using Excel 2003 then you can have a maximum of 256
coulmns....

Pl. respond on how you want to handle...

Give row nos of first few you want to handle...

"bioyyy" wrote:

Hello:

I need your help desperately. Transpose the columns into rows with a
condition. For example,

Q R S T U V
X Y Z AA AB
Row 26 6 A1 B1 C1 D1 1:1 1:2
12:2
Row 27 5 B2 C1 -- -- --- --

So, here are the steps what I would like to you help me,

(1) if row 26, col Q has 6, copy 6 columns from V to AB (ie. # column copy =
number enter in row 26 col Q.
(2) Tranpose and put in col AZ, row 26 (starting on row 26)
(3) Skip 2 rows,
(4) then repeat for row 27. So, if row 27, col Q has 5, copy 5 columns from
V to AA. Tranpose, skip 2 rows and repeat that up to row 1000.

Your help is greatly appreciated.