PivotTable column with comma delimited values

[justmill]

I have some columns of data that have comma delimited values.

Is there a way to make the pivot table realize the values are comma delimited and separate them out for use as filters?

Example:

Please Login or Register  to view this content.

So, when filtering for "Keywords" on the pivot table, it should show:

Phase1
Phase2
Phase3

[ChemistB]

No, you need to separate them before you apply the pivot table and, depending on what data you're looking for, you might need to further rearraign the data so phase 1,2 and 3 are in the same column.

[justmill]

Thanks, that is a very huge bummer though.

[ChemistB]

Maybe if you upload an example spreadsheet showing exactly what you want the results to look like (a dummy pivot table), we can figure out a way to get there.

[alansidman]

OP has requested this be closed. Has opened same issue in Commercial Services