none
How do I combine similar records with unique characteristics without duplication RRS feed

  • Question

  • Combine similar records with unique characteristics without duplication I have a list of data that looks like this:

    |key |last |first| email| degree

    |1|Hope|Bob|a@1.com |BA

    |1|Hope|Bob|a@2.com MA

    |1|Hope|Bob|a@1.com|PhD

    |2|Pane|Pat|b@1.com|BA

    |2|Pane|Pat|b@2.com|MD

    I needed to combine this data to show multiple variants of the same field to look like this:

    |key|last|first|email1|email2|degree1|degree2|degree3

    |1|Hope|Bob|a@1.com|BA|MA|PhD

    |2|Pane|Pat||b@1.com|BA|MD| Null

    The columns would need to "generate" as needed. e.g., If there was only 1 record that had 19 emails, it would generate 19 email columns even if the rest only had a max of 2.


    • Edited by Nishley Monday, March 2, 2020 2:33 PM
    Monday, March 2, 2020 2:32 PM

All replies