The have the below data in one cell in excel
Employee number: 12345
Employee name: Name
Phone Number: 1234567890
Job Role: Trainee
Start date: 15-10-2018
I want the data to be split to various columns with their values below them.
|Employee number |Employee name | Phone Number |Job Role |Start date|
|12345 | Name |1234567890 | Trainee | 15-10-2018|
Can anyone help me out?
Thanks in advance