Summarize Duplicates in Range and Keep All Column Headings

[2Ruff4U]

Hello, I have a range of data that has, among other things, sales in a transaction and an Account ID. I am trying to keep this list with the same column headings but if there are duplicates in the Account ID (because that account had more than one transaction) I want to keep the column headings, just keep the one Account ID with the sum total of all the instances of that Account ID and remove the duplicates. The result will be a list with the same column headings, unique Account IDs and the total for all transactions if there is more than one for that Account ID. I tried Subtotals but I lose the column heading and a Pivot Table doesn't seem to keep them either.
Thank you

 

[2Ruff4U]

With Power Query you can summarize you data as you wish very quickly. If you repost your data using XL2BB, then I will provide you with a solution. Cannot manipulate data in a picture. Since you are running 365, PQ is an integral part of your version and does not require any addins.

Thank you for responding. I will investigate Power Query, didn't know about it and sounds promising. For now I had to move on from this issue but I greatly appreciate your suggestion.

 

[Legacy 143009]

Appreciated the reply, I did find the cause when I researched the error 6 and saw, as you asked, that it could be in the number length. I found a few data types formatted as "custom", with the ### in the field. Corrected that and all was well!

Happy you have figured it out

 

[alansidman]

If you are truly interested in Power Query, then I suggest you get this book found on the Mr Bookstore

Master Your Data with Power Query in Excel and Power BI

Despite the moniker "data monkey," we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time...

www.mrexcel.com