I don’t know why I’m having such trouble with this task but I can’t seem to do this. I’m using a REST Get against our CRM system to extract the phone numbers related to a contact ID. Since there are four distinct types of phone numbers that can exist per contact, I end up with four rows per contact ID.
In reality, I’d like one row for the contact but with one column for each phone type. Anyone know how to do this? Help is always appreciated. (see image for my starting point).