I have attached an Excel, which contains Data in the first column as raw data.
The data is starting with some identifiers as: Alphabet, Roman Number, Number, Small Alphabet & Article No.
I want to separate the data in different column as per the starting value of the data, I have made columns to demonstrate what exactly is the end result.
The last column is called Check, which actually should provide the result if the values in column A are contained somewhere from column C to column G.
Thanks in advance!