Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Analyze SharePoint multiple values field in an Excel pivot table

  1. #1
    New Member
    Join Date
    Jul 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Analyze SharePoint multiple values field in an Excel pivot table

    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!

  2. #2
    New Member
    Join Date
    Oct 2009
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Analyze SharePoint multiple values field in an Excel pivot table

    Hi Larry

    I'm curious if you ever found a solution to the above problem?

    I'm have the exact same issue where i need to analyse a SharePoint list in a pivot table and the multiple choice values shows up with ";#" seperators.

    Best regards
    Stine

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •