I have daily time punch data for a single individual that I want to change
from rows to columns. My data is different than I have encountered before
and the array I might normally use won't work here. Worksheet is formatted
as follows:

A - SSN
B - Workday
C - Time Punch number (1, 2, 3 and/or 4)
D - [unrelated data]
E - [unrelated data]
F - Time Punch (time of day, i.e., 8:00 AM)

Example:

xxx-xx-xxxx 12/30/03 1 2:18 PM
xxx-xx-xxxx 4 8:10 PM
xxx-xx-xxxx 12/31/03 1 9:18 AM
xxx-xx-xxxx 2 2:20 PM
xxx-xx-xxxx 3 2:51 PM
xxx-xx-xxxx 4 5:45 PM

Some days have all Time Punch numbers 1 thru 4 (column C); some days only
have 1 and 4, or 1 or 2 and 3, etc.

Can someone help? Thank you so much!

heyredone