Copy data into cells until changes trigger new copy

G

Guest

In column C is the name of an "employee A" follwowed by multiple rows of
data specific to this employee with no further data in column C until the
next employee, "Employee B". The same sequence repeats itself for Employee
B,then C,D.... There are more 5,000 employees contained in this spreadsheet.
Is there a way to copy the employee name into each subsequent row of
column C until the name changes and then repeat the same process for all
employees?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top