how to consolidate the data using c#?

Question

How to consolidate the data using c# , how can we implement the excel's data consolidation funtions in c# windows form application &  save &  generate the consolidated data on button click?