‘Transposing’ columns (2000)

Topic

New Reply

(Edited by HansV – added

 and 

tags to preserve indentation)

I’ve column A listing names and B listing related codes. I want to copy this information into column D with the names followed alternately with the code. For example

John   A1      becomes      John
Mary   B1                   A1
                            Mary, etc..

I’m using =OFFSET($A$1, ,MOD(ROW(A1),2)) where MOD handles the column references. How can I obtain the sequence 0,0,1,1,2,2, etc., to handle the row references? Andy.

Reply | Quote

Replies

Does INT(ROW()/2) do what you want?

Reply | Quote

Yes, thank you. It creates the sequence 0,1,1,2,2, etc.; I can just copy the first row’s details. If the rows I’m copy from and too are not the same, I can add or subtract an appropriate number.

Reply | Quote

Yes, thank you. It creates the sequence 0,1,1,2,2, etc.; I can just copy the first row’s details. If the rows I’m copy from and too are not the same, I can add or subtract an appropriate number.

Reply | Quote

Does INT(ROW()/2) do what you want?

Reply | Quote