Combine duplicate rows and sum the values with Consolidate function

[ScottXe]

Can the consolidate function be used with more than 2 columns. I would like to have the results with other relevant columns, not just the column to determine duplicates and other one with values to be summed up. If so, your guidance pls.

 

[Rx_]

Yes, anything can be done.
Would you upload a small sample of some general data to show what the goal is? Just guessing your goal has some business rules dealing with duplicates.
A visual would be very helpful.

 

[ScottXe]

I attached a sample file for illustration of the issue. The raw data part consists of 5 columns. Using consolidate function to accomplish the task by using SKU and QYT columns only. However I need to output the report together with Supplier and Cat columns. How can I alter the consolidate function to achieve it or I have to use other function? Thanks for your advice!

 

[stopher]

A pivot table will consolidate the data for you by as many columns as you want. Suggest you switch the view of the pivot to classic view and also hide the totals.