Coherently Organizing Columns (Charges on an Invoice Report)

[a718]

I have an invoicing report that breaks all charges down just like this:

Original Report

My desired output (open to suggestions if there's something more intelligent) is one where I can see the transaction number, its reference number, and all the types of charges associated with it, like so:

Desired Output

Can someone please assist?

[ImadZidan]

Hello @a718 ,

Do you have a dataset we can work with?

Please attach and we will do it.

[a718]

Hi ImadZidan,

Absolutely, please see attached. For confidentiality purposes, I changed the transaction and reference numbers, as well as added an arbitrary value to the cost numbers. Should still be solveable, all the same. In this instance, there are no ExtraAmount4's, but in the future there might be! 

[a718]

@ImadZidan (sorry, forgot to tag you)

[ImadZidan · Accepted solution]

Hello @a718 ,

Please have a look at the attached.

I hope you find it helpful.

I see in the final output the order of the charge type may need to be looked. May be not. the choice is yours.

Any issues, shout back.