Better way to Group Data

[EmilyXu0101]

I have thousands of data about the employee's work time schedule from Monday to Sunday. And everyone is different.

Is there any way I can group the employees who have the same work time schedule (exactly same starting time and ending time, and everyday should be matched)?

[gawa]

hi @EmilyXu0101 

Summarize tool would help. Assuming that your dataset looks like this;

1) Combine start-time, end-time, and day of week by Formula tool.

2) Sort data by name of employee and day of week (if order of your dataset is at random)

3) Concatenate column created at step1 (group by employee name) by Summarize tool

4) Tile tool (method: Unique Value) would output group of each employee having the exact same work schedule as below.

Please look into attached workflow for more detail.

[EmilyXu0101]

Hi gawa

My dataset is different from your set, not sure if see my attachment.

[gawa]

@EmilyXu0101 

Sorry I missed your dataset, but workflow is almost same, just transpose input data into vertical one like I did in previous post.

[gawa · Accepted solution]

I change mind. If you dataset is originally in horizontal shape, simply using Unique tool would suffice.