Reorganize table to combine each pair of records into one record

1. 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. 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.

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

this is way tooo hard for me

4. 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. 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.

6. 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.

7. 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. Re: Reorganize table to combine each pair of records into one record

You're welcome.

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.

Page 2 of 2 First 1 2

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

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