I'm new to the forum world so bear with me.
I have a list of employees with 3 columns (Name, Job Code, and Shift #). I need to have a table that shows 3 sections for each shift, and across the top of the section would have the job code. Under the job code would show a list of those names that are for that shift and for that job code.
Its not too difficult to create the table manually with a few filters and copy and paste. But the large company I work for has hundred of employees and the labor report is changing every week, so it would be nice to have it update simply by pasting the new labor report in from an email (the labor report comes out in the 3 column format (Name, Job Code, and Shift #)).
Current Data on the left, table needed on the right... I hope the post looks good enough...
<colgroup><col style="width:48pt" span="8" width="64"> </colgroup><tbody>
</tbody>
I have a list of employees with 3 columns (Name, Job Code, and Shift #). I need to have a table that shows 3 sections for each shift, and across the top of the section would have the job code. Under the job code would show a list of those names that are for that shift and for that job code.
Its not too difficult to create the table manually with a few filters and copy and paste. But the large company I work for has hundred of employees and the labor report is changing every week, so it would be nice to have it update simply by pasting the new labor report in from an email (the labor report comes out in the 3 column format (Name, Job Code, and Shift #)).
Current Data on the left, table needed on the right... I hope the post looks good enough...
NAME | JOB | SHIFT | SHIFT | 1 | |||
Lisa | 1150 | 1 | JOB | 1150 | 2102 | 3455 | |
Doug | 1150 | 1 | NAMES | Lisa | Homer | Mike | |
Homer | 2102 | 1 | Doug | ||||
Mike | 3455 | 1 | |||||
Bart | 1150 | 2 | SHIFT | 2 | |||
Marge | 2102 | 2 | JOB | 1150 | 2102 | 3455 | |
John | 2102 | 2 | NAMES | Bart | Marge | Joe | |
Joe | 3455 | 2 | John | ||||
Kevin | 1150 | 3 | |||||
Maggie | 2102 | 3 | SHIFT | 3 | |||
JOB | 1150 | 2102 | 3455 | ||||
NAMES | - | Maggie | Kevin |
<colgroup><col style="width:48pt" span="8" width="64"> </colgroup><tbody>
</tbody>
Last edited: