I have data in a column called "company" it lists 3000 companies along with the company type - whether it is LLC, LP, Corp, etc. The format is like this: Microsoft_LLC_LLC. I want to remove the LLC portion and put it in another column called lets say company type. Any ideas? Much appreciated. An Image of example of data set is posted.
