Headers Within Data - Messy Export

[ethanschuttler]

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

[Inactive User · Accepted solution]

Solution attached.

[ethanschuttler]

Incredible - thanks Ryan!