I have an excel which is attached for reference.
The issues I am having are as follows:
In column A the text contains text as Art. & then number. When the text is only Art. I can separate it conveniently in Column I. However when the text is contained in a string, I can use the formula to separate it in another column L.
The required result should be that the Art. with no. should all be in column I & after that removed from Column A irrespective of the fact if it's alone or contained in the string.
2. (Workbook = Modified)
a) The text which is assigned to columns from C to F should be removed from column A
b) The relationship between columns is that
F is child of E
E is child of D
D is child of C
Whenever there is a value in F the value of E is repeated accordingly, same goes for other parent child relationship.
I have tried to put this in the workbook to make it clear, however please let me know if something is not clear.
Lastly the column I will always have values, that means if the row is empty in Column I, it will be deleted.