Data Parse

[geeksqaud]

How do I parse Data from one single column to multiple? i tried text to columns it didn't worked. is there any other way to parse the data?

Date Case Reported

12/9/20
Time Case Reported
3:09 pm
Last Name:
Will
First Name:
Smith
ID#:
12345
Location:
Chicago
Phone Number:
123-555-1234
Test Date
12/9/20
First Day :
12/6/20
Last day :
12/6/20
involved?
Yes

[ImadZidan · Accepted solution]

Hello @geeksqaud ,

Please have a look at the attached. Hopefully it will give you an idea.

Let me know if more needs to be done.

[geeksqaud]

I used "\n" as a delimiter and it fixed the issue. Thank you Imad