+ Reply to Thread
Results 1 to 1 of 1

create unique list from multiple values?

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    create unique list from multiple values?

    Hi everyone,

    I have a problem that I can not solve on my own. I have a list of employees with salary data for different time periods (from date - to date). Same employee can therefore appear on multiple rows on that list.

    I need to transform that into a list into a list with employee number as a row headers and months of 2011 as column headers and populate that list with date for actual salary for that month from above list.

    I enclose an example of how the list look like.

    Grateful for any tips and tricks that you might throw my way.

    Best regards to you all.

    Attached Files Attached Files
    Last edited by dragganm; 10-26-2011 at 03:33 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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