The result with Pivot column to rows
SSIS CSV Parser Transform – Pivot Option (Runtime view – Normalize CSV string)
The result with Pivot column to rows