Multi-Row Formula Help: Moving Name from above time to next to the below rows

[Gr4c3Sult]

Hi All,

We receive a report with time for employees in a funky format.  The name of the employee is above the time block in an out for a week.  Then the employee ID and Assignment are listed under the name.  I need the name, employee ID and Assignment ID in its own column adjacent to the day worked. Additionally, there are subtotals for each department I need deleted.

I have tried a few things, but can't get the results I need.  A file with a sample of scrubbed original data is attached with a sheet showing what the desired results are. You help is greatly appreciated as always!! :)

Thanks,

Grace

[binuacs · Accepted solution]

@Gr4c3Sult One way of doing this with the multi-row tools

[Gr4c3Sult]

Works Perfectly!  Thank you!!  

<3 this community!!