|
|
| Author |
Message |
Mustals
|
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
Excel264
|
| |
|
| |
 |
| |
|