New User - break out multiple transaction rows - each with own tax - into 1 row

[Databuilds906]

I want to break out multiple transaction rows (with same trans #), and each with its own tax (each row carries a different tax), into a single row with the taxes in their own column. Any suggestions? 

[IraWatt]

Hey @Databuilds906,

Would you be able to give an example table of what your looking to achieve at the end? 

[DataNath · Accepted solution]

Hopefully interpreting this right - is this what you're looking for when you say 'with the taxes in their own column'?

[Databuilds906]

This is awesome level of support! Thank you.