This may be a little confusing...to a beginner, me.
Instead of entering data in two worksheets can I:

In worksheet A

a1 b1 c1 d1
date # time place

20 oct 77 940 OH
21 oct 99 1240 NY
22 oct 101 745 OH
22 oct 128 545 PA
22 oct 222 655 NY

In worksheet B

a1 b1 c1 d1
date pa ny oh
20 oct 77
21 oct 99
22 oct 128 222 101

22 oct can be three seperate rows but would prefer one.

Can this be done or am I stuck entering the data twice?