Consolidate and Sum the Rows

[Johnzea]

I have tried the basic 'Data' then select 'Consolidate' then 'Sum' etc.....looking for some help to sum up the QTY and SYM and get rid of the dups...I have attached (2) images...the 'Before' and what I'm looking to accomplish with the 'After'...any help with this would be very much appreciated..

Johnzea

 

[sandy666]

You attached nothing

try to post a link to shared excel file with representative example and expected result. use GoogleDrive, OneDrive or any similar.

 

[Johnzea]

When I right click on the image icons in the body of the thread and select view image i can see the images...Ok I will use GoogleDrive with a new thread..

 

[sandy666]

this is your whole post so re-read post#2

attachments from your local computer will not work

 

[Johnzea]

Ok TY...new at the forum I will change..

 

[sandy666]

no problem

have a nice day