Turn Excel into simple Database

[Adaminski]

Maybe this won't be simple. I work for a school who doesn't have a database program. We do trips every winter and organizing them by hand is a nightmare. Here is a simple list of information we do but have about 25 trips. Timestamp gets priority, then Option 1 and so forth. If there is a way to show me how this would work with this basic set-up, I should be able to work it out. Say there is a limit of only two on a trip.

Timestamp	Last Name	First Name	Option 1	Option 2	Option 3
12:01:23	Bates	Kathy	Fencing	Under the Sea	Bahamas
12:01:20	Cromwell	Oliver	Fencing	Atlanta	Under the Sea
12:01:25	Dickens	Charles	Fencing	Bahamas	Atlanta
12:01:22	Franklin	Rosalind	Fencing	Under the Sea	Bahamas
12:01:19	Glenn	John	Fencing	Atlanta	Under the Sea
12:01:21	Kristopherson	Kris	Fencing	Under the Sea	Bahamas
12:01:24	Thatcher	Margaret	Fencing	Bahamas	Atlanta

<tbody>
</tbody>

Thanks for any and all help.

 

[mole999]

Make sure you have a date in there so you can group by day, you could then select the lot and use a pivot table (loads of self help on youtube for the basics, and obviously ask questions here