Post by Seth on Sept 4, 2012 13:07:18 GMT -6
I am trying to upload an Excel file that has a column with cells that has cells with multiple values. The values are currently separated by semi-colons. I need to upload this file to the Sharepoint where the Sharepoint column is formatted as a Choice > Checkboxes column.
When I try this now, Sharepoint creates an index with all the different permutations of the values in the column, rather than a list with only the unique values. For example, I have Jim, Bob, and Billy, and rather than listing just those three names, it lists
Jim
Jim, Bob
Jim, Billy,
Jim, Bob, Billy
etc
Ideally, Sharepoint would take the values in my Excel file and then check the appropriate boxes based on the unique values. In other words the Sharepoint form would just have Jim, Bob and Billy, and the appropriate boxes would be checked based on the values in the Excel file.
When I try this now, Sharepoint creates an index with all the different permutations of the values in the column, rather than a list with only the unique values. For example, I have Jim, Bob, and Billy, and rather than listing just those three names, it lists
Jim
Jim, Bob
Jim, Billy,
Jim, Bob, Billy
etc
Ideally, Sharepoint would take the values in my Excel file and then check the appropriate boxes based on the unique values. In other words the Sharepoint form would just have Jim, Bob and Billy, and the appropriate boxes would be checked based on the values in the Excel file.
