Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'Transposing' columns (2000)

    (Edited by HansV - added <!t>[pre]<!/t> and <!t>[/pre]<!/t> 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<pre>John A1 becomes John
    Mary B1 A1
    Mary, etc..</pre>

    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.

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Transposing' columns (2000)

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

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Transposing' columns (2000)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •