- Under the column
position
,Edit cells
-Split multi-valued cells...
- Select
by separator
- enter the separater|
in the text box - clickOK
- Under the column
position
-Facet
-Text Facet
- Under the column
position
,Edit cells
-Join multi-valued cells...
- Enter the separator
|
in the text box - ClickOK