John Luciani

John Luciani

  • NA
  • 23
  • 17.5k

C# Excel search and combine

Jan 10 2014 10:14 AM
Hello,
I have an excel file I generate through a C# program. The file is a combination of data from two database tables organized by Product, Part Number, and Month. I am trying to find an elegant way to combine fields by searching by Part Number and Month and adding the necessary fields together. The below orange highlighted fields are what I need to find and the yellow is what needs to be added together. Essentially take these two sections and combine them into one. 
If someone could point me in a good direction that would be awesome!
 
PRODUCTCOMMODITYREPORT_DATEFRUPNYYYYMMMONTHYRFRUCNTDIFREPLTARGET
FRU_FF_ALL_USDDD201309504899820121012-Oct40761256842525000
FRU_FF_ALL_USDDD201309504899820121112-Nov40341203650525000
FRU_FF_ALL_USDDD201309504899820121212-Dec40221242322525000
FRU_FF_ALL_USDDD201309504899820130113-Jan40181243811525000
FRU_FF_ALL_USDDD201309504899820130213-Feb40261123270525000
FRU_FF_ALL_USDDD201309504899820130313-Mar40231246034525000
FRU_FF_ALL_USDDD201309504899820130413-Apr40221204712525000
FRU_FF_ALL_USDDD201309504899820130513-May40131241660525000
FRU_FF_ALL_USDDD201309504899820130613-Jun39791189242525000
FRU_FF_ALL_USDDD201309504899820130713-Jul39371218163525000
FRU_FF_ALL_USDDD201309504899820130813-Aug39281215722525000
FRU_FF_ALL_USDDD201309504899820130913-Sep39181171423525000
          
PRODUCTCOMMODITYREPORT_DATEFRUPNYYYYMMMONTHYRFRUCNTDIFREPLTARGET
FRU_FF_ALL_ESDDD201309504899820121012-Oct164565074198525000
FRU_FF_ALL_ESDDD201309504899820121112-Nov1642649240712525000
FRU_FF_ALL_ESDDD201309504899820121212-Dec164995089167525000
FRU_FF_ALL_ESDDD201309504899820130113-Jan16612510790145525000
FRU_FF_ALL_ESDDD201309504899820130213-Feb1650146125512525000
FRU_FF_ALL_ESDDD201309504899820130313-Mar1657751062213525000
FRU_FF_ALL_ESDDD201309504899820130413-Apr1671549895211525000
FRU_FF_ALL_ESDDD201309504899820130513-May1673051683225525000
FRU_FF_ALL_ESDDD201309504899820130613-Jun1679050024244525000
FRU_FF_ALL_ESDDD201309504899820130713-Jul1672051594218525000
FRU_FF_ALL_ESDDD201309504899820130813-Aug1684951789713525000
FRU_FF_ALL_ESDDD201309504899820130913-Sep1685550293313525000
 

Answers (7)