Consolidate, Delete Duplicates and Sum

[Johnzea]

What I'm trying to accomplish is to consolidate the rows and sums along with getting rid of the duplicates on the same worksheet by using a Macro..Any Help in the right direction would be very much appreciated..

Johnzea

https://drive.google.com/file/d/1FjqU1iQIszx-v3d43lM0LZquwZNrzfLQ/view?usp=sharing


https://drive.google.com/file/d/1FjqU1iQIszx-v3d43lM0LZquwZNrzfLQ/view?usp=sharing

 

[alansidman]

I cannot manipulate data in a picture to demonstrate a solution. You would have been better served uploading an actual file. However, if you create a pivot table from your data, it should give you the expected results.

 

[Johnzea]

Let me know if this helps

https://drive.google.com/file/d/10xuuMSx6EBJrqr8rgec5-sbPIwkf6n9q/view?usp=sharing

 

[Johnzea]

Update

https://drive.google.com/file/d/11HvBzvDXcR9BzTOh-iwNSbL3m-xudgAX/view?usp=sharing

 

[alansidman]

If you unhide column F and give it a column header name, then you can create a pivot table and arrange the columns as needed. See

https://app.box.com/s/vucxv7d4ov8c2b4rgze26ky9rxx2dndy

those columns can be rearranged as desired.

If you are unfamiliar with PTs then look at this tutorial https://www.contextures.com/CreatePivotTable.html