I have taskcard program that outputs work accomplished at an auto repair facility and tracks by a specific workcard. Unfortunately, I need data rolled up to a higher level. Output is sorted by column B - Car Nbr and then by Column G - Workcard. I would like to generate a new tab in each spreadsheet that rolls up similar workcards into 1 unique number for each car and then repeated for the next car and any labor hours in columns D and J would be summed together
- These two unique lines would only show up as 1 entry in the output tab with any labor hours for both lines summed together
-These items would show up as one entry "0018" with the the "_xxx" removed and the hours summed together
-These items would show up as one entry "1855" with the the "/001" removed and the hours summed together
-These would show up as one entry "21-97-01" with the "/001" removed and hours summed together
-These would show up as one entry "C1234AB" with the "_XXXX" removed and hours summed together
See attached sheet where I show the input and the desired output.