Attached is a sample file. How can I best parse this data?
The data looks as shown in column A. I need to find a way to fill in the Number, Code, and Priority cells as shown in columns B, C, and D. Sometimes a Priority value exists, and sometimes it does not in the column A data.
In this sample file I filled in the Number, Code and Priority values to look as I would like them to look after the data has been automatically parsed.
I will have many files like this with many rows of data like this.
Can someone help me with this?
Bookmarks