I have a spreadsheet with a data dump that lists contact IDs and tags for each contact ID. The tags represent the caller, the type of call & the state of the call.
Each contact ID should have 3 tags and currently each tag appears on a separate row while duplicating the contact ID.
I've extracted a list of unique contact IDs to a separate list. Now what I'm trying to do is get each type of tag (Caller, type & state) into a separate column by matching to the contact ID. I've created a table that identifies the tags that belong into each category, but how can I populate the column?
Each contact ID should have 3 tags and currently each tag appears on a separate row while duplicating the contact ID.
I've extracted a list of unique contact IDs to a separate list. Now what I'm trying to do is get each type of tag (Caller, type & state) into a separate column by matching to the contact ID. I've created a table that identifies the tags that belong into each category, but how can I populate the column?