Hi everyone,
I've got a spreadsheet extracted from a timekeeping software. It gives me data in two columns:
Column A lists the associate's name, tasks, and activities per task.
Column B lists the hours entered for each.
For example:
However, this format is not very usable for the analysis I'd like to conduct. I can manually insert the appropriate associate's name in a new column, and do the same thing for the Task #, but that takes a great deal of time. I'm looking for some way to do this automatically. I'm thinking an if() function may be useful, and then recording a macro, but I can't seem to crack this nut.
Here's what I'd like it to look like:
I have two tabs on the attached spreadsheet, which is an example of the data I'm working with. The 'Currently' tab shows how the data is originally. The 'As Needed' tab shows how I'd like it to be, after some automated fashion.
Thanks in advance for your help!
test test.xls
Bookmarks