+ Reply to Thread
Results 1 to 4 of 4

how do i join 3 row and skip the fourth row and repeat till the end of all 600 rows

  1. 11-28-2013, 12:27 AM #1
    excel_psychopath
    excel_psychopath is offline
    Registered User
    Join Date
    11-14-2013
    Location
    london. on
    MS-Off Ver
    Excel 2010
    Posts
    3

    how do i join 3 row and skip the fourth row and repeat till the end of all 600 rows

    how do i join 3 rows and skip the fourth row and repeat till the end of all 600 rows.

    i have data like this all in cellA1 going down"

    first and lastname
    address
    city+st+zip

    first and lastname
    address
    city+st+zip

    first and lastname
    address
    city+st+zip

    first and lastname
    address
    city+st+zip

    so i want to join row1+row2+row3 to look like this eg"frank mica+123 some st+ columbus 43231 oh"

    better yet if i can automatically put each row into each own cell .. so that i have fname and lnama in one cell the address in the next cell , the city+zip+s in the next one,

    cause i wanna be able to do mailings...and u know mail merge only works when the data in different cells.

    thanx in advance.
    Reply With QuoteRegister To Reply
  2. 11-28-2013, 12:54 AM #2
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: how do i join 3 row and skip the fourth row and repeat till the end of all 600 rows

    It would be helpful if you upload a sample workbook with enough sample data to let us know about your requirement. Your sample workbook may contain two sheets. One is Before and another is After. In the Before sheet you just put the sample data and in After sheet you show what output you expect.
    Last edited by sktneer; 11-28-2013 at 12:56 AM.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  3. 11-28-2013, 12:55 AM #3
    ramananhrm
    ramananhrm is offline
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: how do i join 3 row and skip the fourth row and repeat till the end of all 600 rows

    Please try this file.
    Attached Files Attached Files
    Please click 'Add reputation', if my answer helped you.
    Reply With QuoteRegister To Reply
  4. 11-28-2013, 12:55 AM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: how do i join 3 row and skip the fourth row and repeat till the end of all 600 rows

    Hi and welcome to the forum
    If your data looks like this...
    A
    B
    C
    D
    E
    2
    		 1first and lastname 1first and lastname 1address 1city+st+zip
    3
    		 1address 2first and lastname 2address 2city+st+zip
    4
    		 1city+st+zip 3first and lastname 3address 3city+st+zip
    5
    		 4first and lastname 4address 4city+st+zip
    6
    		 2first and lastname
    0
    0
    0
    7
    		 2address
    0
    0
    0
    8
    		 2city+st+zip
    9
    10
    		 3first and lastname
    11
    		 3address
    12
    		 3city+st+zip
    13
    14
    		 4first and lastname
    15
    		 4address
    16
    		 4city+st+zip


    Then in C2, copied across to E2 and down as far as you need it, use this...
    =OFFSET($A$1,(ROW($A1)-1)*4+COLUMN(A1),0)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Repeating sum formula every fourth block of rows
    By sjshah82 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-26-2013, 04:13 PM
  2. Split columns at the fourth ''/'', repeat after '';''
    By Zvetam in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 11-08-2012, 10:23 AM
  3. Add a Row, then Skip to next row and Repeat
    By talkinggoat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2010, 07:50 PM
  4. Lock Cell based on Condition and Repeat till Last Row
    By georgeanaprop in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2010, 07:23 AM
  5. Quick Macro question - How to delete two rows then skip one - and repeat
    By David Smithz in forum Excel General
    Replies: 3
    Last Post: 03-03-2006, 11:00 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1