Forum Discussion

Copper Contributor

Apr 22, 2021

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

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 earn...

excel

Riny_van_Eekelen

Platinum Contributor

Apr 22, 2021

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-bfe9-40a9-a8e9-f99134456576#OfficeVersion=Windows

djcraigq

Copper Contributor

Apr 22, 2021

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.