Posts by MarcoTex

So, to ask a dumb Q, how do I use this query on my data? Thanks for helping this newb whose boss thinks he knows what he's doing haha.

Will do. Been stuck with other tasks in the meantime.

Yes, I can build a pivot table but its time consuming and my boss doesn't want to. I am looking for a solution he can do easily without needing me. If it at all possible.

Data changed to spreadsheets. Basically, need to merge rows by Invoice Line and sum both the Tax Rate and Tax Collected columns; leaving the other columns untouched. Also, this is a basic spreadsheet with only 9 rows. The solution would need to work for spreadsheets with hundreds to thousands of rows. Any help would be appreciated. Thank you.

Apologies for that. Didn't realize I could upload data. Will do tomorrow when I am back at work. Thank you.

Trying to take the before photo and make it look like after in Excel (Ill take Access too if you got it). If possible, I need something my boss can run and do it himself simply. Basically, just want to build a template that even he can run without much trouble. Basically need to merge the rows and sum TWO columns: Tax Collected and Tax Rate.