Results 1 to 4 of 4

Thread: How do I parse data in excel from every 4 rows to a new column

  1. #1
    Junior Member
    Join Date
    Mar 2013
    Posts
    2
    Rep Power
    0

    How do I parse data in excel from every 4 rows to a new column

    Hi-

    I want to create a 2 column spreadsheet like this :

    Column A Column B
    Trace A record of the processing of a computer program or transaction. The information collected from a trace can be used to assess problems and performance.
    Transaction ID See transaction identifier

    from
    trace

    A record of the processing of a computer program or transaction. The information collected from a trace can be used to assess problems and performance.

    transaction ID

    See transaction identifier.

    transaction identifier (TID, transaction ID, XID)

    Each item of data to create the column is seperated by 4 rows in excel now.

    Please advise. Thanks.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Why don't you just filter the rows for BLANKS and delete them?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Mar 2013
    Posts
    2
    Rep Power
    0
    Quote Originally Posted by Excel Fox View Post
    Why don't you just filter the rows for BLANKS and delete them?
    Thanks that worked to remove the blanks. How do I move every other row into a column?

  4. #4
    Junior Member
    Join Date
    Apr 2011
    Posts
    6
    Rep Power
    0
    If you don't mind using a helper column you could enter this formula into the helper cells starting, say, on row-2

    =IF(ISEVEN(ROW()),ROW(),""), copied down the column

    The formula returns the row number if the row number is even

    Let's say we use colum-C as the helper and we want to pull the data into column-D

    In D2, copied down: =INDEX(A2:A100,MATCH(SMALL(C2:C100,ROW(A1)),C2:C10 0,0))
    This pull values from every other row into column-A into column-D

    To get column-B values into, say, column-E
    In E2: =INDEX(B2:B100,MATCH(SMALL(C2:C100,ROW(A1)),C2:C10 0,0))

    If the start row of your data begins on an odd numbered row, then use ISODD in place of ISEVEN.
    Afterward, copy the D:E cells and paste back as values only then delete the helper cells.

Similar Threads

  1. Replies: 34
    Last Post: 03-13-2015, 02:26 PM
  2. Move data from rows into columns for every unique value
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 06-13-2013, 03:02 AM
  3. Replies: 9
    Last Post: 12-04-2012, 09:45 PM
  4. Delete unwanted rows & column
    By sanjeevi888 in forum Excel Help
    Replies: 1
    Last Post: 09-30-2012, 08:52 AM
  5. Transpose data into Rows
    By vikash200418 in forum Excel Help
    Replies: 2
    Last Post: 04-10-2012, 11:02 PM

Tags for this Thread

Posting Permissions

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