So I have a SharePoint list with a Nintex Workflow. In one of those columns is data from a multiple checkbox option for branches. Is there a way to parse that data and create a new column in said list that shows the branches so when it is exported to Excel it can be sorted by the branch even when it might have more than one branch?
Is there a reason they cannot analyze it directly in SP? These are questions I always like to ask because sometimes the user doesn't realize the full capability of SharePoint. They often think of it as a glorified file share.
Some folks just like to take the data offline and analyze and do other things outside of the list. They know it isn't a glorified file share
Sorry, didn't mean to imply that yours did! Just speaking in general.
I suppose you could create a calculated column for each branch, and if your choice columns contains the branch populate the individual branch field with the branch name.