Results 1 to 3 of 3

Thread: Help Organising Data

  1. #1

    Help Organising Data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello all,

    Not sure if this is in the correct part of the forum but here goes.

    I am in dire need of some expert assistance as my limited knowledge of Excel has me completely stumped.

    I have attached a small spreadsheet (just a snippet of the amount of data i actually have to process) that demonstrates the current format and required format.

    there are a set number of columne headings and they are
    Companies
    Ind / Edu Qualifications
    IndustryTechnology
    Positions
    Programming Langs
    International Regions
    UK Regions
    Sector / Vertical Mkt
    Product / Search
    Languages

    If anyone can help me in trying to organize my data I would be hugely grateful.

    many thanks
    Attached Files Attached Files

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    Cross posted here
    Hope that helps

    Roy

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    767
    Articles
    0
    Excel Version
    2010
    Hello Arvon
    If I understand correctly, your wanting a cross tabulation, that shows by candidate ID, the Skill Categories in columns with all the data in C2:C999 shown in its correct Skill Category ?
    So ...... My cross tab starts at B1006. I started by building two unique lists of the candidate IDs and the Skill Categories to provide the row and column headings. This is straightforward using the Advanced Filter.
    I added a helper column (A) to concatenate the Candidate ID and the Skill Category, to simplify the matching process.
    Here is my formula for the transposition, which goes in C1007, and needs copying down and across :
    =IFERROR(INDEX($D$2:$D$999,MATCH($B1007&C$1006, $A$2:$A$999,0)), "")

    Don't forget to update the details on the other website mentioned by Roy.

    Hercules
    Attached Files Attached Files

Posting Permissions

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