+ Reply to Thread
Results 1 to 6 of 6

Database with different degrees for the same person

  1. #1
    Registered User
    Join Date
    08-23-2018
    Location
    UAE
    MS-Off Ver
    2019 business
    Posts
    98

    Database with different degrees for the same person

    attach a file (simple one)
    i have large database for people who apply for job
    some people have more than one degree
    in my example person A have 4 degrees, when i export my data to excel it repeat Person A four time on row
    but i need 1 row but add column for each degree for person A

    How i can do it
    thanks
    Attached Files Attached Files
    Last edited by shj92922; 08-16-2022 at 10:35 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Database with different degrees for the same person

    With a helpcolumn in D

    D2 =A2&COUNTIF($A$2:$A2,$A2) and drag down.

    C27 =IFERROR(INDEX(Table2[#All],MATCH($A27&C$26,Table2[[#All],[Kolom1]],0),3),"") and drag across.


    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,341

    Re: Database with different degrees for the same person

    An other option (for users Excel 365 or 2021):

    Try:

    A27: =UNIQUE(Table2[[Name]:[Nationality]])
    C27: =TRANSPOSE(FILTER(Table2[Degree],Table2[Name]=A27)) and drag down
    Attached Files Attached Files
    Last edited by HansDouwe; 08-16-2022 at 04:00 PM.

  4. #4
    Registered User
    Join Date
    08-23-2018
    Location
    UAE
    MS-Off Ver
    2019 business
    Posts
    98

    Re: Database with different degrees for the same person

    thanks all

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Database with different degrees for the same person

    An alternative is with Power Query

    Please Login or Register  to view this content.
    Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

    It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

    - Follow this link to learn how to install Power Query in Excel 2010 / 2013.

    - Follow this link for an introduction to Power Query functionality.

    - Follow this link for a video which demonstrates how to use Power Query code provided.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Database with different degrees for the same person

    Glad I could help.

    Thanks for marking the question solved.

    You can add reputation by clicking on the star * add reputation to all members who helped you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to Convert DD (Decimal Degrees) to DMS (Degrees Minutes Seconds) in Excel via Function
    By Reahmatullah Ktk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-07-2022, 04:28 PM
  2. Best way to convert Degrees Minutes and Seconds to Decimal of Degrees (and Vice Versa)
    By Aussie_Student in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-05-2017, 02:12 AM
  3. Replies: 4
    Last Post: 07-26-2016, 09:06 AM
  4. Replies: 2
    Last Post: 05-04-2013, 07:33 AM
  5. Converting Lat/Long (Degrees Minutes Seconds) to Decimal Degrees
    By Jeremy Rayne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2008, 06:02 PM
  6. Replies: 2
    Last Post: 04-28-2006, 07:20 AM
  7. [SOLVED] calculate from degrees to degrees/minutes/seconds on excel?
    By C. Hollinger in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2006, 05:00 PM

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