Hi All, i have a problem in here,
I have data like this
Location Date LocationStatus
21 Street 2016-11-24 Drilled
21 Street 2016-11-24 Blasted
21 Street 2016-11-24 Priority1
21 Street 2016-11-24 Priority2
and i want a make the data like this ,
Location Date LocationStatus Priority
21 Street 2016-11-24 Drilled Priority1
21 Street 2016-11-24 Blasted Priority2
Could you help me with this problem.