Combining multiple rows into a single row and including calculating earnings totals

%3CLINGO-SUB%20id%3D%22lingo-sub-2281067%22%20slang%3D%22en-US%22%3ECombining%20multiple%20rows%20into%20a%20single%20row%20and%20including%20calculating%20earnings%20totals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281067%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%20I%20hope%20someone%20can%20help.%20I've%20got%20a%20sheet%20which%20I%20pull%20to%20work%20out%20delivery%20drivers%20earnings.%20How%20do%20I%20combine%20multiple%20rows%20of%20of%20the%20driver%20into%20one%20row%20which%20will%20also%20calculate%20his%20total%20earnings%20thereby%20shortening%20the%20sheet%20and%20giving%20the%20required%20information%20immediately.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20Windows%2010%26nbsp%3B20H2%20Build%26nbsp%3B19042.962%20with%26nbsp%3B%3C!--%20StartFragment%20%20--%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22cf0%22%3EMicrosoft%C2%AE%20Excel%C2%AE%20for%20Microsoft%20365%20MSO%20(16.0.13929.20192)%2064-bit.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22cf0%22%3EI'm%20attaching%20a%20screenshot%20of%20a%20portion%20of%20the%20sheet%20to%20give%20you%20an%20idea%20of%20what%20I'm%20referring%20to.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22cf0%22%3EThanking%20you%20in%20advance%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3C!--%20EndFragment%20%20--%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2281067%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2281959%22%20slang%3D%22en-US%22%3ERe%3A%20Combining%20multiple%20rows%20into%20a%20single%20row%20and%20including%20calculating%20earnings%20totals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281959%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%20for%20your%20reply.%20It%20definitely%20helped%20me%20a%20lot.%20I%20was%20just%20wondering%20if%20there%20wasn't%20an%20easier%20and%20less%20complex%20way%20to%20sort%20the%20data.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2281136%22%20slang%3D%22en-US%22%3ERe%3A%20Combining%20multiple%20rows%20into%20a%20single%20row%20and%20including%20calculating%20earnings%20totals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281136%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1033251%22%20target%3D%22_blank%22%3E%40djcraigq%3C%2FA%3E%26nbsp%3BI%20guess%20you%20could%20summarise%20the%20data%20using%20a%20pivot%20table.%20How%20that%20would%20work%20is%20described%20in%20the%20attached%20MS%20support%20article.%20come%20back%20here%20if%20you%20have%20more%20questions.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576%23OfficeVersion%3DWindows%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576%23OfficeVersion%3DWindows%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi. I hope someone can help. I've got a sheet which I pull to work out delivery drivers earnings. How do I combine multiple rows of of the driver into one row which will also calculate his total earnings thereby shortening the sheet and giving the required information immediately.

 

I'm using Windows 10 20H2 Build 19042.962 with 

Microsoft® Excel® for Microsoft 365 MSO (16.0.13929.20192) 64-bit. 

 

I'm attaching a screenshot of a portion of the sheet to give you an idea of what I'm referring to.

Thanking you in advance 

 

2 Replies

@djcraigq I guess you could summarise the data using a pivot table. How that would work is described in the attached MS support article. come back here if you have more questions.

https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bf... 

Thank you so much for your reply. It definitely helped me a lot. I was just wondering if there wasn't an easier and less complex way to sort the data.