Hi All,
Hoping the community can come to my aid once again with an issue I'm having :)
We have data that we export that has the following format:
Column Header
Employee Name (1 cell)
Date Range (Multiple Cells)
Employee Name (1 cell)
Date Range (Multiple Cells)
etc.. for about 200 employees.
What I need, is that employee name in a column preceding the dates, until the next employee name is encountered, and then that would take over the cell value. So something like:
Column Header 1 Column Header 2
Employee Name 1 Date 1
Employee Name 1 Date 2
Employee Name 1 Date 3
.
.
.
Employee Name 2 Date 1
Employee Name 2 Date 2
etc..
Any thoughts?
Thanks!
Ethan
