I have a lot of data and I want to write a formula.
I have four companies in my data XYZ, XY, AB and CD. as you can see in below data. Original Data sometime contains company name sometimes there is no company name in front of original data. I want to keep same original data in desired output...