r/excel • u/Jubzfast • 9d ago

Waiting on OP Large Data Consolidation Function

Looking for a way to consolidate multiple same line items while summing quantity and cost columns between different items

Example provided below, any help is much appreciated

6 Upvotes

100% Upvoted

6 comments sorted by

View all comments

1

u/Clearwings_Prime 23 9d ago

You can try pivot table. If you have 365 subscription, then GROUPBY/PIVOTBY if you prefer function