Results 1 to 10 of 10

Adapt CONCATENATE to skip rows

Threaded View

  1. #1
    Registered User
    Join Date
    10-29-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    18

    Adapt CONCATENATE to skip rows

    Hi,

    I'd like to know how adapt the CONCATENATE function to skip rows when copying the formula down a column. For example I am merging rows 3 & 4 using =CONCATENATE(Sheet1!$C3:$AN3,Sheet1!$C4:$AN4) onto Sheet 2 row 3 but it would be very helpful if I could then merge rows 5 & 6 from sheet 1 on row 4 of sheet 2 automatically.

    When I copy the formula down currently sheet 2 cell c4 reads =CONCATENATE(Sheet1!$C4:$AN4,Sheet1!$C5:$AN5)

    Any thoughts?
    Attached Files Attached Files
    Last edited by Celex005; 10-29-2012 at 04:43 PM. Reason: Advised

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1