Getting rid of duplicates

[ARW17]

I want to present a schedule for someone who works in multiple departments. The output should have each IntervalStart time once and either working or not and if working, which department are they working in.

So I'm using 1/0 for working/not working.

Department 1's schedule
0 0 0 0 1 1 1 1 0 1 1 1 0 0 0 0 0 0 0 0 0
Department 2's schedule
0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 0 0 0 0

I want my output to be
T1
T2
T3
T4
T5 Department 1
T6 Department 1
T7 Department 1
T8 Department 1
T9
T10 Department 1
T11 Department 1
T12 Department 1
T13
T14
T15 Department 2
T16 Department 2
T17 Department 2
T18 Department 2
T19
T20
T21
T22

But since I have 2 departments, I'm getting each time period twice.

Advice please

 

[xenou]

Using a select distinct would probably remove the dupes (which in general should be those with 0 -- if someone is actually working in two departments at the same time, then you would still get two records I guess).