Copy rows with unique combination of columns, then sum
Got a tricky one... I'm trying to harmonize data from one sheet to a new one. I've got data shuttle pumping data from a source Excel file in OneDrive to a raw data Smartsheet. I then want to copy the rows from the raw data sheet, but sum values in the target sheet into a single row if a combo of two columns matches. See below:
Is this possible? Thanks in advance!