I have a CSV file with one column having some data e.g
Alloy/Data
Alloy/Data/Eveready (3 level)
Alloy/Data/All/Cocacola (4 level)
I want the structure changed so that the last string in 3 & 4 level or higher level is deleted & copied to another column.
And now the structure changes to:
Alloy/Data
Alloy/Data
Alloy/Data/All
The other column:
Empty
Eveready
Cocacola
I think it can be done via a macro. Thank you.