Coherently Organizing Columns (Charges on an Invoice Report)

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?

Datasets

Gallery

Parse

Help

Accepted answers

ImadZidan

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.

InvoiceBreakdown.yxzp

All comments

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!

20200827 Invoice Sample Data Redacted.xlsx

a718

@ImadZidan (sorry, forgot to tag you)

ImadZidan

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.

InvoiceBreakdown.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703