Creating columns from multi-line data
I have an excel file from a user that I have put into Data Prep. One of the columns contains multi lines of data. Can Data Prep split those lines into separate columns?

------------------------------
Janet Grimsley
VP, Business Intelligence
The Fauquier Bank
Warrenton VA
(540) 349-0215
------------------------------

------------------------------
Janet Grimsley
VP, Business Intelligence
The Fauquier Bank
Warrenton VA
(540) 349-0215
------------------------------