Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a structure like this Current Department/Responsibility unique code/Target Department

I want to create a new sheet where I will put down all the new departments(target departments) and draw all responsibilities that refer to each one of them. The problem is that it is a one (Dpt) to many (resp.) relationship and I don't know how can i add the necessary lines.

share|improve this question
    
You could create a list of unique Responsibilities by inserting a Pivot report to a new Excel sheet. Then you could copy the resulting list into another new sheet and use the Excel function VLOOKUP to find the referenced Target Department. VLOOKUP is explained here: grbps.com/Excel6.pdf An alternative to the Pivot report is to copy the responsibilities and use the Data menu to sort the list and remove duplicate entries. – Axel Kemper Apr 12 '13 at 14:59
    
thank you Axel I like the Pivot solution although it will need some manual adjustments – Theodore Apr 12 '13 at 16:03

You must log in to answer this question.

Browse other questions tagged .