Results 1 to 5 of 5

Create an Summary List from a data set

Threaded View

  1. #1
    Registered User
    Join Date
    08-29-2012
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    23

    Create an Summary List from a data set

    I have the following Excel file (made up numbers):

    RptLOB     GLR  CLR 
    Disability 5      3      
    Disability 2      1      
    MSL        4      6      
    NoLOB      3      2      
    AE         2      5
    NoLOB      3      5
    and I'm trying to find a way how to code it so in a new file, I get the following: (I've already created the new workbook with the column names)

    RptLOB     ECMAccount  Amount 
    Disability GLR          7    (Sum of GLR when RptLOB = Disability)  
    Disability CLR          4    (Sum of CLR when RptLOB = Disability)  
    MSL        GLR          4    (so on....)
    MSL        CLR          6
    NoLOB      GLR          6
    NoLOB      CLR          7
    AE         GLR          2
    AE         CLR          5
    So basically, however many columns I have (GLR, CLR....in actuality I have 12 columns), that's how many times each RptLOB should be mentioned in my new file (the GLR, CLR values when the RptLOB is Disability and MSL, and so on - I have 46 different LOBs but this may change so I don't want to fix the amount)

    What is the best way to approach this?

    Any help will be appreciated!
    Last edited by kotonikak; 09-13-2012 at 05:11 PM. Reason: Corrected thread title to topic only, as per forum rules, don't forget!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1