What I have is a report looking like this
these four records refer to the same Agent, as as you see eveything but the reason code and not ready reason time, repeat.
What I need to make of this, is that I can create individual columns for each of the possible Reason code Dimensions and then display the time that belongs to that dimension only so I can display these four rows as one, my problem is if I do Foreach to get the individual time filtering by Reason code, I will still get four rows.
any help will be greatly appreciated.
What I want to achieve would look something like this.