Sort by Column

[emvella]

Hi,


I copy from a website and paste in excel like this:
https://yadi.sk/i/B8kbXytFc6b19w


I don't know if it is possible or not.
What I want is that I Sort the list by column C (time) but because each game is in 2 rows then I cannot do it because I am having a mess like this:
https://yadi.sk/i/-vbH9AzC7oMFLg


I want to Sort them like this:
https://yadi.sk/i/5hodV2BqrslKbQ


Thanks

 

[emvella]

Yes it is ok now and exactly what I want .

I really thank you!

 

[emvella]

The only problem is when there are more then 1 game starting with the same time.

 

[Special-K99]

Your test data had no repeated times.

in H2
=IF(B2<>"",TEXT(B2,"hh:mm")&D2,H1)
in I2
=(B2<>"")*1+(AND(B2="",D2<>"")*2+AND(C2="",D2="")*3)

Select the range to sort on (not complete columns) including columns H and I
Sort on column H
and column I

 

[emvella]

Wow that is great, I really thank you again!