Reformatting Raw Data

I get raw data from our POS system and I need a quick way to re-sort it (will be done weekly), so i can drop it into a PowerPivot DB for analyzing/reporting. Of the raw data all I need are the rows with dates in column A, but i also need to pull the name of the employee into Column D for classes they worked.

In the raw data the employee name (beginning) and sub totals for each employee are always offset from the data i want the same, but the amount (rows) of data for each employee varies. Example of raw data and re-sorted data attached.

Performance Parsing.xlsx

Hi..

lol.. I got beaten by one of the Masters..

My stab at it anyway..

Click the Button on the "Before" sheet to see the results on the "Test" sheet..

My code is based on the assumption that:
The Name value is the ONLY value in Column A that has a comma in it AND no word "Total" in that string..

Please Login or Register  to view this content.

Hi..

Thanks for the advice.. very much appreciated..

Hi..

Did you try my solution?

JBeaucaires solution is better.. but i am just curious to see if my solution worked for you too..