move two columns of data to four columns

[PB]

Hi,

Using Excel 2003
I need a little help. I have time punches that are coming out of a report
into two columns in Excel. I need it to be in four columns so I can analyze
the data better. Any help would be great.

This is how the data is retrieved – Time in is in one column and Time out is
in one column.

Last Name First Name Employee Payroll ID Department Pay Group Worked
Department State Day In time Out time Out Punch Type Hours Earnings Code
Doe John 1000001152 11100 123456 CZHRLY 123456 P Wednesday 1/6/2010
6:08 1/6/2010 12:02 LP 5.9
Doe John 1000001152 11100 123456 CZHRLY 123456 P Wednesday 1/6/2010
12:51 1/6/2010 16:05 3.23


Need data to look like this. Four columns for time in, time out, time in,
time out.


Last Name First Name Employee Payroll ID Department Pay Group Worked
Department State Day In time Out time In time Out time Out Punch
Type Hours Hours Earnings Code
Doe John 1000001152 11100 123456 CZHRLY 123456 P Wednesday 1/6/2010
6:08 1/6/2010 12:02 1/6/2010 12:51 1/6/2010 16:05 LP 5.9 3.23


Does anyone have any ideas, I am open to anything.
Thanks
PB

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

I can look tomorrow. Easy enough to do with a macro from the bottom up to
move up and over and delete old row.