2

We're using SharePoint Online (Office 365) and Excel 2013. Can you configure a multiple-choice column in a SharePoint list to have the answers be exported into individual cells in Excel 2013? We're allowing more than one answer in the multiple-choice column, but when it exports into Excel all of the answers get combined into one cell with a hash tag in-between them, which makes reporting a hassle.

2

I guess first you should export to excel format and Merge what ever you want to the cell.

https://www.ablebits.com/office-addins-blog/2013/10/13/merge-columns-excel-without-losing-data/

0

There is no easy way to do this that I've found. You can filter the column in SharePoint that has the multiple choice, I would suggest the easiest way is to create a new view and filter data if appropriate within SharePoint.

You could also group items in the view options, see if that makes it easier

Otherwise you're stuck trying to split the data apart in Excel

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.