Better way to Group Data

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)?

Test.xlsx

Datasets

Accepted answers

Gawa

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

1187528_gawa_rev2.yxmd

All comments

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.

1187528_gawa.yxmd

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

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

1187528_gawa_rev2.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703