larrybryant
New Member
- Joined
- Jul 23, 2002
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
I have a SharePoint list with a Choice field that will allow multiple values. I would like to be able to analyze the data in an Excel pivot table.
There are no problems exporting the SharePoint list to Excel, however when the Choice fields (that permit multiple values) are exported they are placed in a column with the multiple choices separated with ";#".
For Example:
Products Capabilities
Shovel Dig;#1;Bury;#2;Cover;#3
Rake Dig;#1;Cover;#3
Hammer Dig;#1;Hang;#4
Pitchfork Cover;#3
The functions are not mutually exclusive and a product may have one or many capabilities.
I am looking for the best method for normalizing the multiple-value fields so I can analyze the data using a pivot table.
Any suggestions would be GREATLY appreciated.
Thanks!
There are no problems exporting the SharePoint list to Excel, however when the Choice fields (that permit multiple values) are exported they are placed in a column with the multiple choices separated with ";#".
For Example:
Products Capabilities
Shovel Dig;#1;Bury;#2;Cover;#3
Rake Dig;#1;Cover;#3
Hammer Dig;#1;Hang;#4
Pitchfork Cover;#3
The functions are not mutually exclusive and a product may have one or many capabilities.
I am looking for the best method for normalizing the multiple-value fields so I can analyze the data using a pivot table.
Any suggestions would be GREATLY appreciated.
Thanks!