Time punch data from rows to columns

[heyredone]

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

 

[Shane Devenshire]

Hi,

Show us what you want the data to look like.

 

[heyredone]

Shane,

Reading your response ... I realize I did not indicate how I wanted the
final data to look like. My apologies. Using my example, I'd like for it to
look like the following with the time data going across left to right:

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

Whereas column G is time punch #1, H is time punch #2, I is time punch #3, J
is time punch #4. If it is not possible to display time punch #4 in column J
because there is no time punch #2 &/or #3 for an individual (like example
above), then I can possibly accept time punch #4 displaying in column H.

Also, since the applicable Workday is not included in every cell in column B
except the first time there is a time punch for a day, will that cause a
problem? Do I need to fill in the Workday into each cell in column B? If
so, is there an easy way to do that without copying & pasting manually?

Thanks ever so much!
--
heyredone

Hi,

Show us what you want the data to look like.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

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

 

[heyredone]

Shane,
By the way, I am using Excel 2003
Thanks!
--
heyredone

Hi,

Show us what you want the data to look like.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

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