Forum Discussion
Solved
Mergin duplicates from list but adding their values
Hi, I would like to merge a few lists together to get total of each resources needed. Is anybody have an idea or any suggestion which could help me into it? (Thanks in advance, and sorry if my e...
I would create a pivot table based on the data.
Add the Resources field to the Rows area and the Need field to the Values area; Excel should automatically use SUM as aggregate function.
I would create a pivot table based on the data.
Add the Resources field to the Rows area and the Need field to the Values area; Excel should automatically use SUM as aggregate function.
Fab! I will have a look on this feature I am not familiar with as soon I'm off tonight, but it seems very solid!
Thanks very much HansVogelaar, as soon I try that, I'll come back with review.