Your request is an easily solvable task
To turn the concatenated data into separate columns,
Select the 3 Columns
Go to
Cols=>Utilities=>Text to Columns
Enter the "|" as the delimiter column
Click on OK
To transpose the columns go to (this is actually a stacking of the columns)
Tables=>Stack
Set up the dialog box like below

Click OK and you will get

Jim