Shane,
Thank you for your response. As you can see from the e-mail string, I did
use Glenn's array suggestion and it worked wonderfully.
Thanks again for responding.
--
heyredone


"ShaneDevenshire" wrote:

Hi,

You can transpose data using either the =TRANSPOSE(A1:A4) function or using
the copy Paste Special Transpose command.

You may want to write a macro to do one or the other of these. But first
test to see which works for you, then record a macro to convert one row of
data and post it as a new question and ask for help generalizing it to n rows
of data.

For the Transpose function you highlight four cells, type the formula and
press Shift Ctrl Enter, to enter it

--
Thanks,
Shane Devenshire


"heyredone" wrote:

Hello,

I have a very large amount of data (workday time punch data) that I need to
alter from multiple rows to multiple columns on one row. See small example
of data as follows where FirstName, LastName, Badge, Store, ScanDttm, RAW,
CONVERTED are column headings (A1 thru G1):

FirstName LastName Badge Store ScanDttm RAW CONVERTED
ROBERT H. CASAVAN 600265 1211 1/2/2004 28:00.0 9:28:00 AM
ROBERT H. CASAVAN 600265 1211 1/2/2004 57:00.0 2:57:00 PM
ROBERT H. CASAVAN 600265 1211 1/2/2004 24:00.0 3:24:00 PM
ROBERT H. CASAVAN 600265 1211 1/2/2004 03:00.0 5:03:00 PM
BRIAN BAUM 600760 1211 1/2/2004 36:00.0 9:36:00 AM
BRIAN BAUM 600760 1211 1/2/2004 05:00.0 3:05:00 PM
MICHAEL ANTOSIK 600820 1439 1/2/2004 52:00.0 9:52:00 AM
MICHAEL ANTOSIK 600820 1439 1/2/2004 06:00.0 1:06:00 PM

I want to take the CONVERTED data (time punch in & out time) for ROBERT H.
CASAVAN on 1/2/04 (ScanDttm) and spread those 4 in & out time entries into 1
row and multiple columns. Then the same for BRIAN BAUM, and the same for
MICHAEL ANTOSIK, etc. Each individual will have from 1 to 4 in & out entries
on a given day.

Is there a way to accomplish this without copying and transposing each set
of in & out time entries for each person and each day separately? If so, how
do I do that?

Thank you!
--
heyredone