in reply to Parsing multiple rows of text and converting to columns

Does your data look like:
> <Study Design|2|Additional Findings|1|Timepoint> 15 > <Study Design|2|Additional Findings|1|Timepoint Unit> Days > <Study Design|2|Additional Findings|1|Dose (Mg/Kg)> 20 > <Study Design|2|Additional Findings|1|Average Value> 412.22 > <Study Design|2|Additional Findings|1|Sd> 61.05 > <Study Design|2|Additional Findings|2|Timepoint> 15 > <Study Design|2|Additional Findings|2|Timepoint Unit> Days > <Study Design|2|Additional Findings|2|Dose (Mg/Kg)> 20 > <Study Design|2|Additional Findings|2|Average Value> 71.74 > <Study Design|2|Additional Findings|2|Sd> 11.07
Or does it look like this (no blank lines inbetween).
> <Study Design|2|Additional Findings|1|Timepoint> 15 > <Study Design|2|Additional Findings|1|Timepoint Unit> Days > <Study Design|2|Additional Findings|1|Dose (Mg/Kg)> 20 > <Study Design|2|Additional Findings|1|Average Value> 412.22 > <Study Design|2|Additional Findings|1|Sd> 61.05 > <Study Design|2|Additional Findings|2|Timepoint> 15 > <Study Design|2|Additional Findings|2|Timepoint Unit> Days > <Study Design|2|Additional Findings|2|Dose (Mg/Kg)> 20 > <Study Design|2|Additional Findings|2|Average Value> 71.74 > <Study Design|2|Additional Findings|2|Sd> 11.07