Sorry in advance for the long explanation; I don't know how to explain this succinctly:
I have an Excel worksheet with 106 rows of contact data (plus a header row) and data on those contacts in columns A through S.
Columns I through S contain data "tags" that were applied to my contacts by Infusionsoft, my CRM program. However, Infusionsoft doesn't separate my tags into individual columns when I export to a spreadsheet; rather, it gives me one massive column containing all my tags separated by commas. So I used Excel's Text-to-Columns function to expand the tag data from the original single column into 11 columns.
Because Infusionsoft doesn't sort these tags in any order and just dumps them all into a single column of data, once I use Text-to-Columns to separate them out, many instances of the same tags appear in more than one column. Example: one tag is called "Behavior -> Card Opt-in NDCEL 2016" and has been applied to a number of contacts. But some instances of this tag appear in column I, some in column J, some in column K, etc.
I'm trying to sort all instances of each particular tag into the same column while preserving the rest of the data in the rows. So, using the above example, I want to sort my data so that all instances of the tag "Behavior -> Card Opt-in NDCEL 2016" are sorted into one column, and likewise with each of the other tags.
I've been looking online all day and know there must be a way to do this, but I can't figure it out. I even found someone else asking my question online who included the attached simple diagram, but they got no answers. I would very much like to know how to do this, as it will greatly help me to analyze data on our Infusionsoft contacts. Help!
Data Sort Question.JPG
Bookmarks