Moving Data  
Author Message
Mustals





PostPosted: Top

Excel Programming >> Moving Data

I have the following...

Doe, John


Reg: 8 OT: 2 DT: 4


Smith, Sam


Reg: 8 OT: 4


Jones, Dan


Reg: 8


I want it to read like this

Doe, John Reg: 8 OT: 2 DT: 4
Smith, Sam Reg: 8 OT: 4
Jones, Dan Reg: 8

Currently the original data has the "NAME, NAME" in column A. The OT: and
Time in Columns B and C, and the DT: and Time in columns D and E.

The only constant I can see is if column a has a comma (NAME, NAME) then
find next REG: and copy eight cells to the right and paste them in next to
(NAME, NAME).

Thanks,

Sean

Excel400