Intelligence Report Duplicating Expenses

[gmort]

I have a report that shows each expense for a given time-frame on a separate line. I am looking to adjust this report so that expenses that have a specific exception code show that exception code, but no others. I can't filter to only that exception code, because I need to see all expenses. If I add exception code to the query, it creates a line for each exception code that expense has.

For example- the exception code is OOPCORP. 

I need a column that populates with OOPCORP if that expense had the exception code OOPCORP and is empty if there is no exception code. I do not want other exception codes to show at all. There can only be one line per entry key. 

Any help with this would be greatly appreciated!

[KevinD · Accepted solution]

@gmort reporting questions are difficult because it would take a lot of typing to provide the steps. 

The high level answer to the question is creating either a master detail report or a report with a repeater table. Are you familiar with either of these?