Sorting Data across rows

I've attached the spreadsheet I want to use. As you can see there are three sets of "bootcamper name" and "time" columns

I wanted to know how I can sort by name or time if I were fill in data that started from A7 and B7 all the way down to A43 and B43
then restarts at C7 and D7 all the way down to let's sat C30 and D30

If I wanted to list all the data alphabetically ( or by time ) from A7 and B7 all the way down to C30 and D30, how can I do that? Is is possible?

Please and thank you!

it's possible when you use a macro (VBA)

So I entered in data to make it easier...how can I situate the sorting so upon completion
(this would be an alphabetical sort
A7 would be Amy B7 would be 13
A8 would be Bill B8 would be 27
A9 would be Rick B9 would be 24

Terrible Tuesday.xlsx

copy and paste this in a module and run the macro

Please Login or Register  to view this content.

thank you!