+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 23 of 23

Reorganize table to combine each pair of records into one record

  1. #16
    Registered User
    Join Date
    12-20-2018
    Location
    London
    MS-Off Ver
    Online
    Posts
    12

    Re: Reorganize table to combine each pair of records into one record

    Will this work if people clock in/out in random order? Because that will surely happen, I only input the data one after the other for testing.

  2. #17
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    20,567

    Re: Reorganize table to combine each pair of records into one record

    Well, isnt that exactly what I suggested might be the case. Pity you didn't give us a representative sample to begin with....

    Any formula will now be much more complicated.

    I'll take a look in the morning.
    Glenn



  3. #18
    Registered User
    Join Date
    12-20-2018
    Location
    London
    MS-Off Ver
    Online
    Posts
    12

    Re: Reorganize table to combine each pair of records into one record

    this is way tooo hard for me

  4. #19
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    20,567

    Re: Reorganize table to combine each pair of records into one record

    What is way too hard for you? I didnt come back with an alternative yet!!

  5. #20
    Registered User
    Join Date
    12-20-2018
    Location
    London
    MS-Off Ver
    Online
    Posts
    12

    Re: Reorganize table to combine each pair of records into one record

    been trying to get it to work on my own, il upload what i have done so far for your umm amusement, but yea its hard.
    Attached Files Attached Files

  6. #21
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    20,567

    Re: Reorganize table to combine each pair of records into one record

    It does take a long time to give you the wrong answer, doesn't it...

    A helper, in raw, I2, copied down:
    =INT(A2)&" "&B2

    Then sort the columns on the basis of row I, the helper. I also included a column to reverse it bacl to the original order in J for testing. You can delete it.

    Then variants of the formula that I gave you a mile or so further back up this thread:

    =IFERROR(INDEX(Raw!B$2:B$50,1+2*(ROWS($1:1)-1))&"","")

    See attached. Each shading = different formula.
    Attached Files Attached Files

  7. #22
    Registered User
    Join Date
    12-20-2018
    Location
    London
    MS-Off Ver
    Online
    Posts
    12

    Re: Reorganize table to combine each pair of records into one record

    My savior! This is exactly what i wanted.
    Thank you so much, ill go through the formulas and try to understand them. Thanks again!!!!

  8. #23
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    20,567

    Re: Reorganize table to combine each pair of records into one record

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

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